How to know whether primary key of table has any dependent referential constraints or not? Can we find out that information using USER_COSNTRAINTS and USER_CONS_COLUMNS?
Printable View
How to know whether primary key of table has any dependent referential constraints or not? Can we find out that information using USER_COSNTRAINTS and USER_CONS_COLUMNS?
TRY TO USE THIS QUERY
[CODE]select CONSTRAINT_NAME from user_constraints where CONSTRAINT_TYPE='R' AND R_CONSTRAINT_NAME='PK_TITLE'
[/CODE]
You can pass the name of the primary key to find the dependency.