Enlightensoft's Blog

Helping in your each step

  • Categories

  • Authors

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: