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.
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.