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

In article <58i4h3$jn7_at_speedy.daugherty.com>, thomasf_at_daugherty.com says...
>
>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
>

You could also use my shareware tool GoldView. Goldview shows you lots of information about your schema objects. Table structures, indexes, foreign keys, constraints, triggers, etc...

16 and 32 bit versions are available at:

        http://www.tiac.net/users/markford/index.htm

Mark Ford
Benthic Software
http://www.tiac.net/users/markford/index.htm Quality Oracle Shareware (Come See!) Received on Fri Dec 13 1996 - 00:00:00 CST