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

In <8daca8eb.0108081249.1c25ef_at_posting.google.com> j_p_x_at_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"
Received on Wed Aug 08 2001 - 16:52:40 CDT