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
Messages: 37
Registered: February 2008
Location: pakistan
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.

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: 65085
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Current Time: Tue Jul 25 01:55:10 CDT 2017

Total time taken to generate the page: 0.10657 seconds