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

10/14 15:07
阅读数 0

问题:

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表是否存在?


解决方案:

参考一: https://en.stackoom.com/question/4nXE
参考二: https://stackoom.com/question/4nXE
展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部