Question

在oracle表中，如何根据外键找到另一张拥有这个外键的表。

Answer 1

select * from user_constraints cc where cc.r_constraint_name in (
select c.r_constraint_name
from user_constraints c
where c.constraint_type = 'R'
and c.constraint_name = '??' )

?? 是你外键的名字；spiderrobot 的方法也不错，但是当前用户要有 dba 权限; user_constraints 只能查当前用户的对象

Answer 2

select owner ,table_name , constraint_name from user_constraints;

Answer 3

SELECT OWNER,TABLE_NAME FROM DBA_CONSTRAINTS WHERE CONSTRAINT_NAME=
(SELECT R_CONSTRAINT_NAME FROM DBA_CONSTRAINTS WHERE CONSTRAINT_TYPE='R' AND CONSTRAINT_name='***') ;
***是你外键的名字