Re: Newbie SQL question

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 23 Sep 1999 16:17:32 +0200
Message-ID: <7sdcra$7bs$1@oceanite.cybercable.fr>

select table_name from user_tables;
gives you all your tables.

select owner, table_name from all_tables; gives you all the tables you have access with its owner.

select owner, table_name from dba_tables; gives you all the tables of the database with its owner.

michael_gressman_at_my-deja.com a écrit dans le message <7sda5v$4q4$1_at_nnrp1.deja.com>...
>OK, I know that I can use DESC TableName to describe tables, but what if
>I don't know what the name of the table is? Is there an SQL query that
>will give me a list of the tables?
>
>Thanks,
>Mike
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 09:17:32 CDT