Re: What is max. column name size?

Michael Burr wrote: > 1. When naming columns: > > A. How long can names be? select syscolumns.* from systables, syscolumns where systables.tabname="syscolumns" and systables.tabid = syscolumns.tabid; colname tabid colno coltype collength colname 2 1 0 18 tabid 2 2 2 4 colno 2 3 1 2 coltype 2 4 1 2 collength 2 5 1 2 5 row(s) retrieved. SE v5.x says 18 characters, you might run the same query to see if your version differs. > B. What characters can be used (any special characters illegal) ? Well, Informix columns (unlike Sybase and others) are not case sensitive. If you create a column named Name, it'll translate back to name. Other than that, I'd stick with alphanumerics and the underscore character. -- ----------------------------------------------------------------------- Daniel James - Database Administrator djames@statsci.com DAPD Div of MathSoft (formerly StatSci) (206) 283-8802 x284