constraint ---OCP--047--259
SQL> desc user_constraints Name Null? Type ----------------------------------------- -------- ---------------------------- OWNER VARCHAR2(30) CONSTRAINT_NAME NOT NULL VARCHAR2(30) CONSTRAINT_TYPE ---约束类型 VARCHAR2(1) TABLE_NAME ---表名 NOT NULL VARCHAR2(30) SEARCH_CONDITION LONG R_OWNER VARCHAR2(30) R_CONSTRAINT_NAME VARCHAR2(30) DELETE_RULE VARCHAR2(9) STATUS ---约束状态,是否in use VARCHAR2(8) DEFERRABLE VARCHAR2(14) DEFERRED VARCHAR2(9) VALIDATED VARCHAR2(13) GENERATED VARCHAR2(14) BAD VARCHAR2(3) RELY VARCHAR2(4) LAST_CHANGE DATE INDEX_OWNER VARCHAR2(30) INDEX_NAME VARCHAR2(30) INVALID VARCHAR2(7) VIEW_RELATED VARCHAR2(14)
SQL> col CONSTRAINT_NAME for a35
SQL> col SEARCH_CONDITION for a35
SQL> select constraint_name,constraint_type,search_condition,r_constraint_name,delete_rule,status
from user_constraints;
ORACLE约束类型:
PRIMARY KEY 主键
UNIQUE KEY 唯一键
FOREIGN KEY 外键
NOT NULL 非空
CHECK键