How can I find which tables reference a given table in Oracle SQL Developer?

In Oracle SQL Developer, if I’m viewing the information on a table, I can view the constraints, which let me see the foreign keys (and thus which tables are referenced by this table), and I can view the dependencies to see what packages and such reference the table. But I’m not sure how to find which tables reference the table.

For example, say I’m looking at the emp table. There is another table emp_dept which captures which employees work in which departments, which references the emp table through emp_id, the primary key of the emp table. Is there a way (through some UI element in the program, not through SQL) to find that the emp_dept table references the emp table, without me having to know that the emp_dept table exists?

11 Answers
11

Leave a Comment