Replacing a Check Condition

You can delete a CHECK condition from an individual column.

You can replace a CHECK condition on a column in the same way as you would add a CHECK condition.

This statement adds or replaces a CHECK condition on the city column of the office table:

ALTER TABLE office
MODIFY city
CHECK ( city IN ( 'city_1', 'city_2', 'city_3' ) )