Blog » By Jack Vamvas on SQL Server DBA
Modify a SQL CHECK CONSTRAINT
Question: How do I modify a SQL Server CHECK CONSTRAINT?
Answer : To modify a CHECK constraint, you must first delete the existing CHECK constraint and then re-create it with the new definition
An example
ALTER TABLE dbo.MYTABLE DROP CONSTRAINT MYTABLE_contsraint_name ALTER TABLE dbo.MYTABLE WITH CHECK ADD CONSTRAINT MYTABLE_contsraint_name CHECK ( Partition_Key >= Minimum_table_month AND Partition_Key
