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