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

Regards
Michel
Previous Topic: disable procedure
Next Topic: Views underlying table on separate machine
Goto Forum:
  


Current Time: Mon Aug 21 11:02:15 CDT 2017

Total time taken to generate the page: 0.01191 seconds