Usage and Examples of SQL ALTER COLUMN Keyword

SQL Keyword Reference

ALTER COLUMN

ALTER COLUMN command is used to change the data type of a column in the table.

The following SQL changes the data type of the 'BirthDate' column in the 'Employees' table to type year:

ALTER TABLE Employees
ALTER COLUMN BirthDate year;

SQL Keyword Reference