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

Home -> Community -> Mailing Lists -> Oracle-L -> Foreign Key constraint Script

Foreign Key constraint Script

From: Ashish Shah <ar_shah_at_yahoo.com>
Date: Mon, 17 Jul 2000 08:14:36 -0700 (PDT)
Message-Id: <10561.112177@fatcity.com>


Hi All,

Does any one have any script that will tell me a Table has been referenced (foreign key) in how many other tables. I had a tough time droping a table since
it was refered by so many other table.

I tried looking user_constraints but it doesn't give you information about primary table.

TIA.



Ashish
Toronto, Canada

Do You Yahoo!?
Get Yahoo! Mail Free email you can access from anywhere! http://mail.yahoo.com/ Received on Mon Jul 17 2000 - 10:14:36 CDT

Original text of this message

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