Re: Describe Method on all Tables

Many ways.
Here is one. In sqlplus
spool myfile
select 'desc '||owner||'.'||table_name from dba_tables order by owner,table_name;
spool off
spool results
_at_myfile
spool off

Or make a report on dba_tables, and dba_tab_columns that will show the information using a
report writer or sqlplus.
Jim

"Jesse James" <jjames_at_infosage.com> wrote in message news:3bab2efd$1_1_at_athena.netset.com...
> I would like to know if there's an argument/statement that I can use to
> retrieve all table definitions, such as (Name, Null? Type)
>
> I'm not sure how to word this; I have 300 tables in a database and I would
> prefer not to have to do a "Describe Custumers" "Describe Vendors" ....
 on
> each table to find out what it consist of.
>
> Can someone tell me if there's an argument that I can us that will show me
> this information.
>
> Sorry if I didn't use the correct terms.
>
>
>
>
Received on Fri Sep 21 2001 - 15:36:28 CEST