Re: Newbie - How can I list all the tables in a schema?

Earvin C. Lim wrote:
>
> How can I list all the tables in a schema?

Sign on to sqlplus as sys, and
select table_name from dba_tables;

for these tables & their descriptions:
select * from dict;

hth
janet Received on Fri Dec 06 1996 - 00:00:00 CST