oracleoracle11gconstraintsreferential-integrity

How can I find out which table a foreign key references?


I have a database without documentation.

There is a table which has a column language_id which is a foreign key to another table. I want to know which table that foreign key references. I don't want to find out just by looking by eye at all the tables because there are about 120 tables and the names are not descriptive unfortunately.

Is there a way to find that?

I am using SQL Developer to query a remote Oracle 11g database.


Solution

  • You say you're using SQL Developer.

    So, just open the table.

    Go to the constraints page.

    Find your foreign key.

    Look at the R_TABLE_NAME column.

    enter image description here