Re: Iterating through designs tables in a given sequence?

x_at_y.z says...

> I'd like to be able to write some SQL that will iterate through all the tables
> in a given schema, returning a row for each column in each table. That row
> would contain table name, field name, and various field properties like size,
> data type, default value...and so-forth.

There are a number of objects owned by the user SYS that you can query.

desc USER_TAB_COLUMNS;

When logged in as the schema owner, try this SQL:

select TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE, DATA_DEFAULT
from USER_TAB_COLUMNS
order by TABLE_NAME;

Geoff M Received on Mon Dec 22 2003 - 19:24:27 CST