Query the table that the primary key is referenced by a foreign key

When you delete some of the tables, you will often encounter a primary key that is referenced by a foreign key in some relational tables and cannot be deleted, and this is the time to find out which table the primary key is referenced, and there is a view in Oracle that can help us do this, it is user_constraints, in the following example, ' TSP          _PK ' is the name of the primary key, ' R ' is a description of the foreign key relationship we want to query: SQL code Select C.constraint_name, C.table_name, C.constraint_type, C.r_constraint_name from user_constraints c where c.r_constraint_name = ' tsp_pk ' and c.constraint_type = ' R '