Thursday, August 5, 2010

Find all dependent tables

SELECT * FROM user_constraints WHERE constraint_type='R' and r_constraint_name in(
select constraint_Name from user_constraints
where constraint_type in ('P', 'U') AND TABLE_NAME='PERSONAS'
);

No comments:

Post a Comment