表的所有外键约束代码,Oracle代码库,德仔网

代码语言

代码分类

【Oracle】表的所有外键约束

作者:宇航 / 发布于2017/10/25/ 704

表的所有外键约束

SELECT /*+RULE*/ D.CONSTRAINT_NAME PK_NAME,

                 D.TABLE_NAME 

                 || '.' 

                 || D.COLUMN_NAME  PK_COLUMN,

                 A.CONSTRAINT_TYPE,

                 B.CONSTRAINT_NAME FK_NAME,

                 B.TABLE_NAME 

                 || '.' 

                 || B.COLUMN_NAME  FK_COLUMN

FROM   DBA_CONSTRAINTS A 

       JOIN DBA_CONS_COLUMNS B 

         ON A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

            AND A.OWNER = B.OWNER

       JOIN DBA_CONSTRAINTS C 

         ON A.R_CONSTRAINT_NAME = C.CONSTRAINT_NAME

            AND A.R_OWNER = C.OWNER

       JOIN DBA_CONS_COLUMNS D 

         ON C.CONSTRAINT_NAME = D.CONSTRAINT_NAME

            AND C.OWNER = D.OWNER

WHERE  D.TABLE_NAME = 'INV_LOCATION_PALLETS'


或

SELECT * FROM DBA_CONSTRAINTS WHERE R_CONSTRAINT_NAME='PK_INV_LOCATION_PALLETS'

试试其它关键字

同语言下

可能有用的

宇航贡献的其它代码(21)