Deleting a Check Condition in Interactive SQL

You can delete a CHECK condition from an individual column.

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

The following 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