Removing Check Conditions on Tables Using Interactive SQL

Use the ALTER TABLE statement with the DELETE CHECK clause to remove all CHECK conditions on a table, including CHECK conditions on all its columns and CHECK conditions inherited from user-defined data types.

For example:
ALTER TABLE table_name
DELETE CHECK
Parent topic: Table and Column Constraints