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键