What is the SQL to return the column list for a particular table and as a followup question, how would one generate a relational list consisting of Database, Tablename, ColumnName, DataType?Thanks!
Use "help table tablename;" to see the list f columns in a table and their datatype information.DBC.columns table would give you information about databasename, tablename, columnaname, datatype and other important information regarding the table columns
Does this work on views?
Hi hurstrescue,dbc.columns returns a lot of NULLs for views and HELP VIEW is based on dbc.columns.But "HELP COLUMN viewname.*" is resolved by the PE and thus returns better info.Dieter