RE: REFENTIAL
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 15 Oct 2004 14:14:41 +0200
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Seema Singh
Sent: Friday, October 15, 2004 13:05
To: oracle-l@xxxxxxxxxxxxx
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/
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
