一 禁用检查约束
1 语法
DISABLE|ENABLE CONSTRAIT constraint_name
2 代码
sql> desc userinfo_c3名称是否为空?类型-----------------------------------------------------------------------------ID NOT NULL VARCHAR2(10)USERNAME VARCHAR2(20)SALARY NUMBER(5)sql>select constraint_name,constraint_type,status from user_constraints2where table_name='USERINFO_C3';CONSTRAINT_NAME C STATUS---------------------------------------SYS_C0011123 P ENABLEDCK_SALARY_NEW C ENABLEDsql> alter table userinfo_c32 disable constraint CK_SALARY_NEW;表已更改。sql" style="font-family: Consolas,status from user_constraints2where table_name='USERINFO_C3';CONSTRAINT_NAME C STATUS---------------------------------------SYS_C0011123 P ENABLEDCK_SALARY_NEW C DISABLED
二 删除检查约束
1 语法
DROP CONSTRAINT constraint_name
2 代码
sql> alter table userinfo_c32 drop constraint CK_SALARY_NEW;表已更改。
