Deleting a Check Condition

You can delete a CHECK condition from an individual column.

To delete a CHECK condition on a column, set it to NULL.

This statement removes the CHECK condition on the phone column in the customer table:
ALTER TABLE customer MODIFY phone
CHECK NULL
Parent topic: CHECK Conditions on Columns