See all tables referencing a primary key

Question

If I have a table "Person", with a primary key 'ID', how can I see a list of tables with foreign keys that points to the "ID" column in the "Person" table?

Although this is indeed a duplication, I think it duplicates this [other Question](https://stackoverflow.com/questions/1143728/how-can-i-find-which-tables-reference-a-given-table-in-oracle-sql-developer), and not the one referenced by the message that Closed this answer on this current page here. — cellepo, Mar 02 '23 at 23:06

score 3 · Accepted Answer · answered Sep 06 '13 at 08:46

3

Use the ALL_CONSTRAINTS system view.

select table_name
  from all_constraints
 where r_owner = 'OWNER'
   and r_constraint_name = 'YOUR_PRIMARY_KEY'

R_OWNER is the owner of the primary key and R_CONSTRAINT_NAME is the name of the primary key.

answered Sep 06 '13 at 08:46

Ben

51,770
36
127
149

See all tables referencing a primary key

1 Answers1