Enlightensoft's Blog

Helping in your each step

  • Categories

  • Authors

Posts Tagged ‘how to find dependent tables’

How to find dependent tables on my table?

Posted by Pankil Patel on October 3, 2012

Based on constraints on my table, how to find dependent tables?

Below is the query which will give me the tables name & constraint name those are related to MY_TABLE:

select table_name, constraint_name, status, owner
from all_constraints
where  r_constraint_name in
 (
   select CONSTRAINT_NAME from ALL_CONSTRAINTS
   WHERE upper(table_name) = ‘MY_TABLE’   
 )
order by table_name, constraint_name;

Advertisements

Posted in Database, Oracle | Tagged: , , , , , , | Leave a Comment »