Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how do I list tables in a database?
If you want all the tables in a database try
select owner||'.'||table_name from ALL_TABLES;
AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu> wrote in article
<33D799BE.110C_at_charlie.cns.iit.edu>...
> ScottEvon wrote:
> >
> > >Subject: Re: how do I list tables in a database?
> > >From: Brijesh <brijesh_at_enteract.com>
> >
> > The answer previously given will work IF you have dba rights. However,
if
> > you're simply trying to determine which tables belong to YOU (or the
user
> > you're logged on as, to be more precise), simply select from either the
> > TAB table or the TABS table. The TAB table is a brief list of each
table
> > in your schema. The TABS table is a similar table with more detail.
> > (Actually, both are Views, but that's not really important here).
These
> > tables will give you a quick list of your tables.....
> >
> > GOOD LUCK!!!
>
> from USER_TABLES OR DBA_TABLES(if you are a DBA)
>
> --
> AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
> Certified Oracle DBA
> WHITTMAN-HART Inc.
> CHICAGO.
>
Received on Thu Jul 24 1997 - 00:00:00 CDT