Re: query referential constraints

The columns are in dba_cons_columns
You will also need to look at constraint_type P means primary
C means check, the constraint is in the column search_condition R is foreign key, the referenced primary key constraint is in r_constraint_name.

Hth,

--
Sybrand Bakker, Oracle DBA
Hop Pham <pham_hop_at_bah.com> wrote in message news:389785C6.D67197BD_at_bah.com...
> Hi,
>
> How do I extract information about about a schema object's referential
> constraints? DBA_CONSTRAINTS view only provides a list of constraint
> names without explicitly identifying the referenced columns. I suppose
> that this will be a joint between DBA_CONSTRAINTS and DBA_INDEXES. I am
> looking for a way to duplicate all constraints from a schema to
> another. Thanks.
>
> Hop Pham
> pham_hop_at_bah.com
>
Received on Tue Feb 01 2000 - 17:01:43 CST