[This topic is migrated from our old forums. The original author name has been removed]
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?