[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. 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.
Hans Bergsten
said
almost 10 years ago
[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
anonymous