[stellation-res] SQL name length question

["Mark C. Chu-Carroll" <mcc@xxxxxxxxxxxxxxxxxxxxx>]

I did a quick look to check how long names can be in SQL, since
prefixing is increasing the name length.  What I found was that
officially, SQL names can be up to 30 characters, but that some DB2
utilities will fail on column names that are not unique within the first
10 characters.

I'm tentatively making the assumption that table names can be up to
30 characters, and column names can be up to 10 characters. Does anyone
know if any of the databases out there are more restrictive than this?

	-Mark

-- 
Mark Craig Chu-Carroll,  IBM T.J. Watson Research Center  
*** The Stellation project: Advanced SCM for Collaboration
***		http://www.eclipse.org/stellation
*** Work Email: mcc@xxxxxxxxxxxxxx  ------- Personal Email:
markcc@xxxxxxxxxxx