Ooops thanks Jason he has to drop the T in the schemaid, I provided the syntax with the T in front also making the assumption he understand the dictionary ☺
Cheers Francois From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Sent: Monday, July 23, 2012 3:20 AM To: [email protected] Subject: Re: Database Names ** 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]<mailto:[email protected]>> To: [email protected]<mailto:[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<http://www.wwrug.com/> ARSlist: "Where the Answers Are"_ _attend WWRUG12 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ ________________________________ Blue Turtle Technologies (Pty) Limited | Reg. no.: 2003/002610/07 | http://www.blueturtle.co.za Gauteng : Tel: +27 (0)11 206 5600 | Fax: +27 (0)11 206 5606 | Midridge Office Estate, International Business Gateway, cnr New Road & Sixth Street, Midrand, 1685 | P O Box 31331, Kyalami, 1684 Western Cape: Tel: +27 (0)87 721 1874 | Fax: +27 (0)21 552 7764 | Unit E6, Century Square, Heron Crescent, Century City, Cape Town, 7446 DISCLAIMER: This email and any files transmitted with it are confidential and are intended solely for the use of the individual or entity to whom they are addressed. This communication represents the originator's personal views and opinions, which do not necessarily reflect those of Blue Turtle Technologies (Pty) Ltd. If you are not the original recipient or the person responsible for delivering the email to the intended recipient, be advised that you have received this email in error, and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you received this email in error, please immediately notify the sender. Thank you. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
