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

From: Mark Styles <news_at_lambic.co.uk>
Date: Tue, 30 Oct 2001 20:41:37 GMT
Message-ID: <ur3utt0vgoue1d2j0b83ljradiqaq65lt1@4ax.com>

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:41:37 CST