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

10/14 15:07

### 问题：

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.Oracle SQL Developer 中，如果我正在查看表上的信息，我可以查看约束，这让我可以看到外键（以及该表引用了哪些表），并且我可以查看依赖关系以查看什么包等参考表。 But I'm not sure how to find which tables reference the table.但我不确定如何找到哪些表引用了该表。

For example, say I'm looking at the emp table.例如，假设我正在查看emp表。 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.还有一个表emp_dept ，它记录了哪些员工在哪些部门工作，它通过emp表的主键emp_id来引用emp表。 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?有没有办法（通过程序中的某些 UI 元素，而不是通过 SQL）找到emp_dept表引用了emp表，而我不必知道emp_dept表是否存在？

0
0 收藏

0 评论
0 收藏
0