如何查看 约束 的具体内容 oracle

SELECT UC.OWNER, UC.CONSTRAINT_NAME, UC.CONSTRAINT_TYPE, UC.TABLE_NAME, UCC.COLUMN_NAME, UC.SEARCH_CONDITION, UC.R_CONSTRAINT_NAME FROM USER_CONSTRAINTS UC INNER JOIN USER_CONS_COLUMNS UCC ON (UC.CONSTRAINT_NAME = UCC.CONSTRAINT_NAME);

USER_CONSTRAINTS和 USER_CONS_COLUMNS视图关联一下。
CONSTRAINT_TYPE 的相关解释如下：
C - Check constraint on a table
P - Primary key
U - Unique key
R - Referential integrity
V - With check option, on a view
O - With read only, on a view
H - Hash expression
F - Constraint that involves a REF column
S - Supplemental logging
如果是check约束，那么在search_condition列能看到具体的内容。
如果是外键约束，通过R_CONSTRAINT_NAME 列能看到参考约束内容。