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.

例如，假设我正在查看 emp 表.还有一个表emp_dept，它捕获了哪些员工在哪个部门工作，通过emp_id引用emp表，emp_id，的主键>emp 表.有没有办法(通过程序中的某些 UI 元素，而不是通过 SQL)找到 emp_dept 表引用 emp 表，而我不必知道 emp_dept 表是否存在?

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?

推荐答案

没有.Oracle SQL Developer 没有提供这样的选项.

No. There is no such option available from Oracle SQL Developer.

您必须手动执行查询或使用其他工具(例如 PLSQL Developer这样的选择).以下 SQL 是 PLSQL Developer 使用的 SQL:

You have to execute a query by hand or use other tool (For instance PLSQL Developer has such option). The following SQL is that one used by PLSQL Developer:

select table_name, constraint_name, status, owner
from all_constraints
where r_owner = :r_owner
and constraint_type = 'R'
and r_constraint_name in
 (
   select constraint_name from all_constraints
   where constraint_type in ('P', 'U')
   and table_name = :r_table_name
   and owner = :r_owner
 )
order by table_name, constraint_name

其中 r_owner 是架构，r_table_name 是您要查找的表.名称区分大小写

Where r_owner is the schema, and r_table_name is the table for which you are looking for references. The names are case sensitive