Exporting Columns Comment

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?

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.

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