[MSSQL] Alter Table

ALTER TABLE table

ADD column_name
data_type [ ( size ) ]
[ DEFAULT value ]
[ NULL | NOT NULL ]
[ PRIMARY KEY | UNIQUE ]
[ CONSTRAINT constraint_name ]

ALTER COLUMN column_name
data_type [ ( size ) ]
[ ( precision [ , scale ] ) ]
[ NULL | NOT NULL ]

DROP COLUMN column_name | [ CONSTRAINT ] constraint_name