And don't forget that it first checks to see if the name is unique, if not it appends 001 or 002 as necessary to make it unique J. Oh.and BTW.I couldn't look at those two links kuz they are both local to your machine.
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ben Chernys Sent: Friday, June 25, 2010 8:52 AM To: [email protected] Subject: Re: Some questions on arschema: ViewName addition release; view name maximum length in MS SQL, other non-Oracle dbs? - resolved ** So, here's the answer. Introduced in 7.1 (not patch 4) If it starts with a non-alphabetic character, prepend "a_" For Informix: 18, DB2: 128; all others: 30 (in spite of the fact that the actual MS SQL limit is 128); I missed "Group" which becomes group_x. ditto for any other SQL reserved words. And there you have it. Cheers Ben _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
