Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: DESC tableName - need an SQL version...
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