Home » SQL & PL/SQL » SQL & PL/SQL » Table relationships
Table relationships [message #404603] Fri, 22 May 2009 07:46 Go to next message
gajini
Messages: 259
Registered: January 2006
Senior Member
Hi,

Is there any query to find parent and child table relationships
in a hierarichal manner based on a particular table and its particular column?

Thanks...

Re: Table relationships [message #404612 is a reply to message #404603] Fri, 22 May 2009 08:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to do it yourself using the views at your disposal.
Search here many questions on the subject have been asked.

Regards
Michel
Re: Table relationships [message #404624 is a reply to message #404612] Fri, 22 May 2009 08:46 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
USER_CONSTRAINTS.

Look for constraints with a type of R (for Referential Integrity)
Previous Topic: suggest me to which one is best way to write query and why? (merged 4)
Next Topic: need function for last month date?
Goto Forum:
  


Current Time: Thu Dec 08 14:31:03 CST 2016

Total time taken to generate the page: 0.12030 seconds