----查询外键
SELECT A.owner 外键拥有者,
A.table_name 外键表,
A.constraint_type 外键类型,
C.column_name 外键列,
b.owner 主键拥有者,
b.table_name 主键表,
b.constraint_type 主键类型,
d.column_name 主键列
FROM user_constraints A,
user_constraints b,
user_cons_columns C,
user_cons_columns d
WHERE A.r_constraint_name = b.constraint_name
AND A.constraint_type = 'R'
AND (b.constraint_type = 'P' or b.constraint_type = 'U')
AND A.r_owner = b.owner
AND A.constraint_name = C.constraint_name
AND b.constraint_name = d.constraint_name
AND A.owner = C.owner
AND A.table_name = C.table_name
AND b.owner = d.owner
AND b.table_name = d.table_name
AND A.constraint_name = '$fk'; --- $fk = FK793C74DA43D9F9EE
查询外键
最新推荐文章于 2021-09-09 20:16:29 发布