Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: REFENTIAL

RE: REFENTIAL

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Fri, 15 Oct 2004 14:14:41 +0200
Message-ID: <JFEEIGBIDOCCDALDIPLNMEABCKAA.lex.de.haan@naturaljoin.nl>


in case you want to see the "real stuff" check out the SYS.DEPENDENCY$ table ...
Kind regards,
Lex.



visit http://www.naturaljoin.nl

skype me <callto://lexdehaan>

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Seema Singh Sent: Friday, October 15, 2004 13:05
To: oracle-l_at_freelists.org
Subject: REFENTIAL

Hi,
Which view will tell how many tables are refering that columns? Let us consider one table tab1 with pk ID,I wanted to know which others tables are refeing ID as FK/reference key. thanks
-Seema



Donít just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 15 2004 - 07:10:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US