Re: Length of table/column names

Chuck Renaud wrote in message <727igf$a06$1@news.xmission.com>... > >Keep in mind that the current ANSI standard is 18 characters. Not >that I wouldn't like to see that feature myself (though I've heard the >limit is 128 chars in 9.2). It depends on what ANSI standard you call "current". This is what "A Guide to the SQL Standard, Fourth Edition" by C.J.Date has to say about it: "A regular identifier is a string of no more than 128 characters, of which the first must be a letter (upper or lower case), while the rest can be any combination of upper or lower case letters, digits and the underscore character ("_")... " This is an authoritative book on SQL 92 standard, published by Addison-Wesley in 1997 (ISBN 0-201-96426-0). I know that some RDBMS vendors use this book as a guide for their own development. However, I am getting somewhat confused about what is the current (or the next upcoming) release of Informix. Art S. Kagel suggests that version 7.31 is supposed to extend the limit to 256 chars. You are saying it will happen in 9.2. What's the scoop? Alex Molochnikov