Microsoft - Microsoft SQL Server - SQL - Constraints - Enable single constraint

ALTER TABLE MyTable WITH CHECK CHECK CONSTRAINT MyConstraint