ALTER TABLE MY_TALBES ALTER CONSTRAINT MY_CONSTRAINT_0008 WITH CHECK ADD (MY_COLUMN IN ('A','B','C','D','E'))
呵呵。我也不知道对不对,但是如果 MY_CONSTRAINT_0008 在更改之前就被约束的话, MY_CONSTRAINT_0008 是不能被修改了的
ALTER TABLE MY_TALBES DROP CONSTRAINT MY_CONSTRAINT_0008 CASCADE;
ALTER TABLE MY_TALBES ADD(CONSTRAINT MY_CONSTRAINT_0008 CHECK(MY_COLUMN IN ('A','B','C','D','E')));