SQLServer Adding a column to a table

Adding a column to existing table is not that hard. One thing to keep in mind, if the column is not nullable then a default value is mandatory.

ALTER TABLE {TABLENAME} 
ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} 
CONSTRAINT {CONSTRAINT_NAME} 
DEFAULT {DEFAULT_VALUE}