Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Reverse engineering data model
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