Home Next Previous SQL MODIFY/CHANGE COLUMN DATA TYPE The ALTER TABLE Statement is used to modify the column data type. Syntax: ALTER TABLE table_name ALTER COLUMN column_name datatype ; Example: Objective: In this example, we will change/modify the datatype of dept column from varchar to nvarchar. ALTER TABLE Tbl_Emp ALTER COLUMN Dept nvarchar(20);