Re: Getting info on constraint from data dict. tables

Hi,

Thanks for the help there; but what I really want to find out is: how do you find out the exact column of that primary key that is being referenced?

Thanks again,
Angela

In article <ejUTdqeB$GA.309_at_cpmsnbbsa03>,   "udaj" <udaj_at_email.msn.com> wrote:
> 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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Sep 24 1999 - 03:15:10 CDT