From: nsouto@optushome.com.au.nospam (Nuno Souto)
Newsgroups: comp.databases.oracle.server
Subject: Re: Help (2nd request) with determining parent key foreign key relationship
Organization: D.C.S. P/L
Message-ID: <3b71390c.3223150@news>
References: <9krakb$ota$1@panix1.panix.com>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 14
Date: Wed, 08 Aug 2001 13:15:32 GMT
NNTP-Posting-Host: 203.164.180.25
X-Complaints-To: abuse@optushome.com.au
X-Trace: news1.blktn1.nsw.optushome.com.au 997276532 203.164.180.25 (Wed, 08 Aug 2001 23:15:32 EST)
NNTP-Posting-Date: Wed, 08 Aug 2001 23:15:32 EST


On 8 Aug 2001 08:17:15 -0400, stanb@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@optushome.com.au.nospam