RE: REFENTIAL
- From: "Powell, Mark D" <mark.powell@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 15 Oct 2004 09:19:15 -0400
I do not know where the link was to since I got a 404 when I tried to follow
it, but the dictionary view dba_constraints view can be used to list all
FK's that reference a PK or UK constraint. This sound like what Seema
wants.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Stephane Faroult
Sent: Friday, October 15, 2004 8:20 AM
To: oracle-l@xxxxxxxxxxxxx; 'Seema Singh'
Subject: REFENTIAL
http://download-west.oracle.com/docs/cd/B14117_01/server.101/b10755/toc.htm[
1]
Regards,
Stephane Faroult
RoughSea Ltd
http://www.roughsea.com
On Fri, 15 Oct 2004 08:04 , 'Seema Singh' <oracledbam@xxxxxxxxxxx> sent:
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
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
