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.
ALTER TABLE table_name DELETE CHECK