There seems to be some difference's between versions of SQL Anywhere on how to get a list of columns and data types for a table. This is the SQL I use:
In some cases, it appears that it doesn't pick up all the columns for a table. Is it the join to systypes?
What SQL can I use across all versions to extract the information in the above query?
I suspect that dbo.syscolumns doesn't list columns that use custom domains. Here's an almost equivalent statement:
answered 09 Dec '09, 18:22