Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse engineering data model

Re: Reverse engineering data model

From: Diane <Diane_at_coalole.demon.co.uk>
Date: Sun, 21 Feb 1999 14:40:53 +0100
Message-ID: <Ad47RKAlzA02Iw4p@coalole.demon.co.uk>


In article <36CF8C72.13501073_at_bpsinfo.com>, Jonathan Tew <jtew_at_bpsinfo.com> writes
>I'm writing a program which needs to be able to reverse engineer a small
>portion of the database model. I've figured out how to query the tables
>from the all_objects view, the column names from all_tab_columns, but I
>can't figure out where to find the key information from. What
>table/view is this stored in?
>
>Thanks,
>Jonathan Tew

all_constraint_cols (?) something like that anyway try querying all_tables looking for tables named %CONSTRAINT% --
Diane Received on Sun Feb 21 1999 - 07:40:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US