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

earvin_at_omega.uta.edu (Earvin C. Lim) writes:

>Hi all,
 

>How can I list all the tables in a schema?
>Thanks!

Connect as the user and issue the following command:

SELECT table_name FROM user_tables;

or connect with DBA access and issue the following command to see tables in SCOTT schema:

SELECT table_name FROM dba_tables
WHERE OWNER = 'SCOTT'; -Mary Kodama Received on Sun Dec 08 1996 - 00:00:00 CST