Sql server change column type

This article is tagged with: Sql server change column type and mysql

sql server change column type

ALTER TABLE table_name
ALTER COLUMN column_name datatype;

sql server change column type

ALTER TABLE table_name
DROP COLUMN column_name;

sql server change column type

ALTER TABLE table_name
ADD column_name datatype;

This article is tagged with: Sql server change column type and mysql