ALTER COLUMN

The ALTER COLUMN command alters the data type of a column in a table.

The following SQL modifies the data type of the “BirthDate” column in the “Employees” table to “year” type.

ALTER TABLE Employees
ALTER COLUMN BirthDate year;