Re: Getting info on constraint from data dict. tables

hi
the column called r_constraint_name [in dba_constraints] gives u the name of the constraint [primary key] which is being referred.

viji

<angelabr_at_my-deja.com> wrote in message news:7sdijb$blr$1_at_nnrp1.deja.com...
> Hi all,
>
> My problem is that I'm trying to find out the exact column that another
> is related to via a foreign key constraint.
>
> Table A Table B
> ---------- ----------
> column U -------> # column V
> column X -------> # column Y
> # column W column Z
>
> For example, Column X in Table A is a reference to Column Y in Table B,
> the primary key of Table B includes the column Y and the column V. By
> using the DBA_CONS_COLUMNS and DBA_CONSTRAINTS tables I can find out
> the column X (in table A) references the primary key of Table B ... BUT
> I don't know how I can determine that column X is only related to
> column Y (and not column V)! Any ideas?
>
> Thanks in advance,
> Angela
>
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Thu Sep 23 1999 - 12:43:00 CDT