Detail Focused
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment