Thread: Primary Key References

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'

You can pass the name of the primary key to find the dependency.