Enlightensoft's Blog

Helping in your each step

  • Categories

  • Authors

Posts Tagged ‘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
   WHERE upper(table_name) = ‘MY_TABLE’   
order by table_name, constraint_name;

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