Getting info on constraint from data dict. tables

From: <angelabr_at_my-deja.com>
Date: Thu, 23 Sep 1999 15:56:35 GMT
Message-ID: <7sdijb$blr$1@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 - 10:56:35 CDT