You have to drop and recreate to modify the list of permitted values.
For more flexibility you should consider replacing the check constraint with a foreign key to an index-organized table containing a list of legal values.
|
Results 1 to 2 of 2
Thread: Modify Check ConstraintsThreaded View
|
Click Here to Expand Forum to Full Width |