Dick Try this. Buddy
CREATE TABLE MyDocCol (MyDocColName TEXT (18), MyDocColTable TEXT (18)) INSERT INTO MyDocCol (MyDocColName,MyDocColTable) + sel sys_column_name,sys_table_Name from sys_columns t1, + sys_tables t2 where T2.SYS_TABLE_TYPE <> 'SYSTEM TABLE' + AND t2.sys_table_id = t1.sys_table_id -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dick Fey Sent: Wednesday, November 25, 2009 10:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Getting a list of DB columns into a table I am starting a documentation package for our database, listing all tables and columns with a description of what they do. (since I am 71, I assume someday Sami Aaron might have to deal with it) We are running 7.5 I was able to project a table list from the SYS_TABLES table, but cannot find a method of projecting a table listing all column names. I assumed that SYS_COLUMNS would provide that information, but it does not. I can do it by writing 'list columns' into a text file, & then manipulating that into a table, but there must be an easier way. Thanks Dick Fey Carpet Broker Inc Lenexa KS
