Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How can I find the related columns?
D. Alvarado wrote:
> Hello, I'm running Oracle 8.1.7 enterprise server on Solaris. I
> wanted to find all the tables/columns that link through a foreign key
> to a column in my table, A.COL1. How would i build a query to achieve
> this?
>
> Thanks, -
http://www.psoug.org
click on Morgan's Library
click on constraints
scroll to the SQL statements at the bottom of the page.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Nov 12 2004 - 00:39:19 CST