list of all tables

[tw...@visa.com]

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

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

[GHouck]

tw...@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
hk...@teleport.com
http://www.teleport.com/~hksys

[Jake Battle]

You can also do:

select * from dictionary

I think this gives you some extra system tables & views

> -----Original Message-----
> From: tw...@visa.com [SMTP:tw...@visa.com]
> Posted At: Monday, August 17, 1998 7:10 PM
> Posted To: tools
> Conversation: list of all tables
> Subject: list of all tables
>
> 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
>

[D1Scully]

In article <6ragog$3bq$1...@nnrp1.dejanews.com>, tw...@visa.com writes:

>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??

SELECT * FROM user_tables

gives a bunch of stuff you're probably not looking for, try

SELECT table_name FROM user_tables

if you're just looking for names.

Al LaPlante