Re: How can I find the related columns?

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 10 Nov 2004 18:14:40 +0100
Message-ID: <41924bec$0$25064$626a14ce@news.free.fr>

"D. Alvarado" <laredotornado_at_zipmail.com> a écrit dans le message de news:9fe1f2ad.0411100750.1389399b_at_posting.google.com...
> 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, -

dba_constraints
dba_cons_columns
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch229.htm#1290750 http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/ch227.htm#1290598

-- 
Regards
Michel Cadot

Received on Wed Nov 10 2004 - 11:14:40 CST