Re: Help (2nd request) with determining parent key foreign key relationship

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Wed, 08 Aug 2001 13:15:32 GMT
Message-ID: <3b71390c.3223150@news>

On 8 Aug 2001 08:17:15 -0400, stanb_at_panix.com (Stan Brown) wrote:

>I posted this to comp.oraclemisc several days ago, and have recieved no
>replies. I could really use a hand here, if someone can.
>

What is it that you want help with? Finding out what is a PK and a FK? If so, look at USER_CONSTRAINTS and USER_CONS_COLUMNS views and search by table_name = '<your table>' and constraint_type in ('P','R');

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Wed Aug 08 2001 - 08:15:32 CDT