Home » SQL & PL/SQL » SQL & PL/SQL » SQL query for finding out the depentent tables
SQL query for finding out the depentent tables [message #302760] Tue, 26 February 2008 23:18 Go to next message
jeer
Messages: 37
Registered: February 2008
Location: pakistan
Member
hi Experts

there is a constraint FK_PK_BOOK_AUTH. This constraint is for Primary/Foreign key between tables Book and Author.
the query:
select table_name from user_constrains where constraint_name ='FK_PK_BOOK_AUTH'

tells the name table Book. please tell me the query that will also tell the name of depentent table i.e. in my case Author.

thanks
Re: SQL query for finding out the depentent tables [message #302778 is a reply to message #302760] Wed, 27 February 2008 00:30 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1236
http://www.dba-village.com/village/dvp_scripts.ScriptDetails?ScriptIdA=1237

Regards
Michel
Previous Topic: How to pass DATE parameter to View
Next Topic: sql
Goto Forum:
  


Current Time: Thu Dec 08 18:48:32 CST 2016

Total time taken to generate the page: 0.08722 seconds