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

If you are logged into the schema:

select table_name from user_tables;

or

select table_name from all_tables where owner = '<SCHEMANAME>';

If you are not in the schema but have access to the tables within the schema.

The dictionary tables are outlined in the Oracle7 Server Reference, Static Data Dictionary chapter.

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

>Hi all,
 

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

>--
>Earvin Lim
>-- Programmer/Analyst
>-- Academic Computing Services
>-- University of Texas at Arlington
>email: earvin_at_omega.uta.edu
>Phone: (817)272-3678

Frank Thomas
thomasf_at_daugherty.com Received on Mon Dec 09 1996 - 00:00:00 CST