这样: 1、 alter table MY_TALBES drop constraint MY_CONSTRAINT_0008 ; 2、 alter table MY_TALBES add constraint MY_CONSTRAINT_0008 check (MY_COLUMN IN ('A','B','C','D','E'));
先删除原约束: alter table MY_TALBES drop constraint MY_CONSTRAINT_0008 ;再增加: ALTER TABLE MY_TALBES add CONSTRAINT MY_CONSTRAINT_0008 CHECK (MY_COLUMN IN ('A','B','C','D','E'));
1、
alter table MY_TALBES
drop constraint MY_CONSTRAINT_0008 ;
2、
alter table MY_TALBES
add constraint MY_CONSTRAINT_0008
check (MY_COLUMN IN ('A','B','C','D','E'));
alter table MY_TALBES drop constraint MY_CONSTRAINT_0008 ;再增加:
ALTER TABLE MY_TALBES add CONSTRAINT MY_CONSTRAINT_0008 CHECK (MY_COLUMN IN ('A','B','C','D','E'));