SQL SERVER – Create Default Constraint Over Table Column

ALTER TABLE Customers
            ADD CONSTRAINT DF_Customers_Address2
            DEFAULT 'UNKNOWN' FOR Address2

(http://blog.sqlauthority.com/2008/05/31/sql-server-create-default-constraint-over-table-column)