Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Describe all tables
HSK wrote:
>
> Hi..
>
> Does anyone have, or know how to make, a SQL-script that describes all
> tables a user owns (Oracle 7.3) ?
>
> regards,
> HSK
spool xyz.sql
select 'desc '||table_name
from user_tables;
spool off
@xyz
--
"Some days you're the pigeon, and some days you're the statue." Received on Thu Aug 26 1999 - 04:20:38 CDT
![]() |
![]() |