Start a new topic

Exporting Columns Comment

[This topic is migrated from our old forums. The original author name has been removed]

Hello, I have a DB that has got 286 tables. Each Table may have up to 100 Columns. For each Column name in each table I need to list the Owner, Table_Name, Column_Name, Data_Type and Data_length. It's easy to to it manually for each table using the GUI. How can I go this in SQL? Does anyone have a simple export statement I can use that will give me that info for all the tables?

[This reply is migrated from our old forums.]

Re: Exporting Columns Comment
Hi Tony, Glad you found a solution. The SQL depends on the database type, but like I guess you found, you can get the SQL from the debug log for most database types. Best Regards, Hans
[This reply is migrated from our old forums. The original author name has been removed]

Re: Exporting Columns Comment
I exported one table using the GUI and record the sql steps.Then I created a script to rerun the sql statements, recoding the table name and output file for each table.