oracle 通过约束名称查询

 

CONSTRAINT_NAME:约束名称

TABLE_NAME:表名

COLUMN_NAME:列名

CONSTRAINT_TYPE;约束类型 P:PrimaryKey  U:Unique Key

 

 

SELECT A.CONSTRAINT_NAME,A.TABLE_NAME,A.COLUMN_NAME,B.CONSTRAINT_TYPE FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B
WHERE A.CONSTRAINT_NAME =B.CONSTRAINT_NAME
AND A.OWNER='SRCBWEB' and a.constraint_name LIKE '%SLOT_IBFK_8%'

 

 

 

记录

FK_JC_MERBER_SYLLABLE_SITE  JC_MERBER_SYLLABLE SITE_ID  R