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

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

This blog shows how to add a default constraint to an existing table

Syntax:

ALTER TABLE tablename
ADD CONSTRAINT constraintname
DEFAULT defaultvalue
FOR columnname