Re: how do I list tables in a database?

From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/07/24
Message-ID: <33D799BE.110C@charlie.cns.iit.edu>#1/1

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