Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Foreign Key constraint Script
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.