Hi Michael, That's an attachment field on a form with the schema ID of 2109. You can run the following SQL statement to determine which form it is.
select name from arschema where schemaId = '2109' T2109 holds record data H2109 holds status history B2109 holds attachment pools B2109C<attachmentfieldid> There will be one of these for every attachment on the form. This is where the actual attachments are stored in the DB. Jason ________________________________ From: "Benz, Michael" <[email protected]> To: [email protected] Sent: Sunday, July 22, 2012 8:54 PM Subject: Database Names ** Hello World Our remedy database is growing a lot faster then we’d like. So we ran a report that show us our largest tables. The bad side is, is that remedy did not name them very nicely at all! Is there any easy way so find out what table is what form? EG: dbo.B2109C1000000351 is 14 GIG and we want to find out why Thank you! Regards, Michael Benz Remedy Developer _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
