--查询指定数据表的外键情况SELECT A.OWNER,A.TABLE_NAME,A.CONSTRAINT_NAME,B.OWNER,B.TABLE_NAME,C.COLUMN_NAME
FROM DBA_CONSTRAINTS A,DBA_CONSTRAINTS B,DBA_CONS_COLUMNS C
WHERE A.R_OWNER=B.OWNER
AND A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND B.OWNER=C.OWNER
AND B.CONSTRAINT_NAME=C.CONSTRAINT_NAME
AND A.TABLE_NAME='&TABLE'
AND A.CONSTRAINT_TYPE='R';稍稍改动就可以查看所有的外键
FROM DBA_CONSTRAINTS A,DBA_CONSTRAINTS B,DBA_CONS_COLUMNS C
WHERE A.R_OWNER=B.OWNER
AND A.R_CONSTRAINT_NAME=B.CONSTRAINT_NAME
AND B.OWNER=C.OWNER
AND B.CONSTRAINT_NAME=C.CONSTRAINT_NAME
AND A.TABLE_NAME='&TABLE'
AND A.CONSTRAINT_TYPE='R';稍稍改动就可以查看所有的外键
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货