Home » SQL & PL/SQL » SQL & PL/SQL » Foreign Key Reference
Foreign Key Reference [message #1525] Thu, 09 May 2002 01:01 Go to next message
Sowrirajan
Messages: 4
Registered: March 2002
Junior Member
How to find what are the tables refering our table ? ie, what are the tables having our table column as foreign key reference ? how to delete a table with a foreign key refered by some other table ?

Report message to a moderator

Re: Foreign Key Reference [message #1530 is a reply to message #1525] Thu, 09 May 2002 06:53 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
1)query dba_constraints view
2) use cascade constraints

Report message to a moderator

Previous Topic: missing Parenthesiss
Next Topic: Batch File to run SQL Program
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 26 18:36:40 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.