I have a table called abs with primary key absId, this is used as a foreign key in couple of tables which I don't know. Is there a way that I can find out how find the names of those tables in which the primary key absId is referenced? I'm using Oracle 10g as the database.
Thanks.
Sql – how to find foreign keys constraints
foreign keyoracle10gsql
Best Answer
If
ABS
is the parent table in the foreign key relationship and the name of the primary key constraint isABS_PK
, you can identify all the foreign key constraints that reference this primary key using theDBA_CONSTRAINTS
view. Something like