Home » SQL & PL/SQL » SQL & PL/SQL » how to get the list of tables having referential integrity connection
how to get the list of tables having referential integrity connection [message #364380] Mon, 08 December 2008 03:57 Go to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hi,

I need to know the tables list of having foreign key relationship
means

I've table t1 and t2 and they have foreign key relation and t2 and t3 also having the same like i've almost 20 tables in connection...

So please help me the script to find like above....

Please let me know if i'm not clear
Re: how to get the list of tables having referential integrity connection [message #364381 is a reply to message #364380] Mon, 08 December 2008 03:59 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Query DBA_CONSTRAINTS.

Regards
Michel
Previous Topic: invoke SQL Loader
Next Topic: page heading in addition to column headings
Goto Forum:
  


Current Time: Wed Dec 07 18:37:34 CST 2016

Total time taken to generate the page: 0.05450 seconds