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: 63909
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: Fri Oct 21 10:53:09 CDT 2016

Total time taken to generate the page: 0.09808 seconds