Re: list of all tables

twang_at_visa.com wrote:
>
> Hi all,
>
> I just start to use the SQL* PLUS. I got a question, how can I get a list of
> all tables. The describe command can diaplay the column of a table, but I
> first I have to know the table name. where and how can I get all the table
> names??
>
> Thank you!
>
> Tong Wang

Tong,

Depending on the type of tables you want to look at:

  SELECT * FROM TABS; (user)
  or
  SELECT * FROM USER_TABLES; (user)
  or
  SELECT * FROM DBA_TABLES; (system)
  or
  SELECT * FROM ALL_TABLES; (system)

Yours,  

Geoff Houck
systems hk
hksys_at_teleport.com
http://www.teleport.com/~hksys Received on Tue Aug 18 1998 - 05:40:28 CEST