Re: Get all table names in a database

From: Allen Shatzer <cdaspr1_at_erols.com>
Date: Mon, 17 Jan 2000 17:41:05 -0500
Message-ID: <8605rk$gv9$1@bob.news.rcn.net>

Sorry to correct you, but all_objects will only provide the objects to which the current user has access via grants.

If you truly want to see ALL tables (and only tables), access a DBA privileged account such as "system" and issue the following query:

select table_name from sys.dba_tables;

Cdr628 <cdr628_at_aol.com> wrote in message news:20000114212935.18704.00000448_at_ng-fb1.aol.com...
> select owner, object_name, object_type
> from
> all_objects
> where
> object_type in ('TABLE', 'SYNONYM', 'VIEW')
> order by
> owner, object_name
Received on Mon Jan 17 2000 - 16:41:05 CST