Re: Describe Method on all Tables

set heading off pagesize 0 echo off feedback off spool desc.sql
SELECT 'DESC ' || table_name FROM all_tables /
spool off

set heading on pagesize 60 echo on feedback on _at_desc.sql

• Anurag _at_

"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:39:39 CEST