SQL Server Transact Basic to Expert - Add Check constraints to existing table

SQL Server Transact Basic to Expert - Add Check constraints to existing table

This blog show how to add a check constraint to an exisiting table

Syntax:

ALTER TABLE tablename
WITH CHECK or WITH NOCHECK
ADD CONSTRAINT  constraintname
CHECK (logicalexpression)