Re: How can we list all the tables in a database?

5603liul_at_vms.csd.mu.edu wrote:
>
> Dear netters:
>
> How can I know what tables I have in my databases?
> Thanks.

Dear David

If you RTFM you will find:

SELECT TABLE_NAME FROM USER_TABLES for the current user's table

SELECT OWNER, TABLE_NAME FROM ALL_TABLES for user's accessible tables

SELECT OWNER, TABLE_NAME FROM SYS.DBA_TABLES (logged in as DBA) for all tables on database

(The above applies to V6, I believe it also applies for V7)

Yours ever

Eddy Received on Tue Apr 18 1995 - 00:00:00 CEST