sql server change column type
snippet in sql

sql server change column type

user6238


ALTER TABLE table_name

ALTER COLUMN column_name datatype; 

sql server change column type

user2574


ALTER TABLE table_name

DROP COLUMN column_name; 

sql server change column type

user2807


ALTER TABLE table_name

ADD column_name datatype;