From: stanb@panix.com (Stan Brown)
Newsgroups: comp.databases.oracle.server
Subject: Re: Help (2nd request) with determining parent key foreign key relationship
Date: 8 Aug 2001 17:52:40 -0400
Organization: PANIX Public Access Internet and UNIX, NYC
Lines: 18
Message-ID: <9kscb8$4n3$1@panix1.panix.com>
References: <9krakb$ota$1@panix1.panix.com> <nae2nt4apcv394kcvdrhbs38a4lsq9687i@4ax.com> <9krp8a$jah$1@panix2.panix.com> <8daca8eb.0108081249.1c25ef@posting.google.com>
NNTP-Posting-Host: panix1.panix.com
X-Trace: news.panix.com 997307560 18691 166.84.1.1 (8 Aug 2001 21:52:40 GMT)
X-Complaints-To: abuse@panix.com
NNTP-Posting-Date: 8 Aug 2001 21:52:40 GMT
X-Newsreader: NN version 6.5.6 (NOV)


In <8daca8eb.0108081249.1c25ef@posting.google.com> j_p_x@hotmail.com (OK) writes:

>Here is what you want:
>________________________

First of all, thanks.

Second I'm at hime now & can't test this till tomorow. Still I have a
question.

This select only seems to return one column name. Is that the Parent key
column, or the child (foreign key) column? Could it return both?


>select u.table_name "Table Name", u.constraint_name "FK Name",
>u.columns "Column Name",
>w.r_constraint_name "PK Name", x.table_name "PK Table Name", u.status
>"FK Status"