Re: DESC tableName - need an SQL version...

Note that, if you need to need to know the owner of an element in one of the 'ALL_' tables, there is usually an 'owner' column.

For example,

SELECT owner FROM all_tables WHERE table_name = 'frobozz';

Mark Styles wrote:

> On Tue, 30 Oct 2001 13:30:34 -0600, Huntress <kaeli96_at_yahoo.com>
> wrote:
> >Mark Styles wrote:
> >> look at tables USER_TAB_COLUMNS, ALL_TAB_COLUMNS
> >
> >Thanks!
> >
> >Where can I come by the names of all these tables I didn't know existed?
> >I am a newbie who had Oracle shoved down her throat with no manual...
> >
> >Is there a list somewhere of all the "common" tables (ones I didn't
> >make) and what is in them...?
>
> Most of them are easy to guess, and you can find them in all_tables,
> or all_objects.
>
> For objects belonging to the user you're logged in as, the tables all
> start with USER_. To look at all objects in the database, use ALL_. To
> look at database stuff, look at the V$ tables.
>
> If you're a DBA, you have access to the DBA_ tables
>
> Looking for tables? ALL_TABLES or USER_TABLES or DBA_TABLES
> Looking for indexes? ALL_INDEXES etc etc
> Looking for index columns? ALL_IND_COLUMNS etc. etc.
> Looking for sequences? USER_SEQUENCES etc. etc.
> etc.
>
> I'm sure these are all in a manual somewhere, but I've never needed to
> look.
Received on Tue Oct 30 2001 - 14:59:54 CST