hanqing posted
SQL Server does not support directly adding or modifying DEFAULT constraints in the ALTER COLUMN clause. ALTER COLUMN is only used to modify the data type, length, or NULL/NOT NULL attribute of a column. To set a default value, you must separately manage the default constraint using ADD CONSTRAINT or DROP CONSTRAINT.
