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