Re: sql commands to get schema info

From: Patrick Hamou <patrick_hamou_at_hotmail.com>
Date: Sat, 23 Oct 1999 04:23:59 GMT
Message-ID: <zLaQ3.21613$Jp4.35498@news20.bellglobal.com>

There is an Oracle Dictionary in Oracle that is documented in the DICTIONARY views, witch has a synonym named DICT

SQL> desc dict

 Name                            Null?    Type
 ------------------------------- -------- ----
 TABLE_NAME                               VARCHAR2(30)
 COMMENTS                                 VARCHAR2(4000)

look for : DBA_TABLES, DBA_CONSTRAINTS, DBA_INDEXES, DBA_CONS_COLUMNS DBA_USERS regards,

Patrick Hamou,
Oracle DBA
patrickhamou_at_hotmail.clom

<stueby_at_my-deja.com> wrote in message news:7uq6r8$71h$1_at_nnrp1.deja.com...
> I am an Oracle rookie. I have inherited a db that was created by
> another party. I would like to examine the schema so I can get all the
> table names, pk/fk constraints, etc. Basically, as much info about the
> current schema as possible. I am not familiar with the commands needed
> to extract this info. Also, where is a good place/reference to find
> this info? Thanks!
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 22 1999 - 23:23:59 CDT