Code has been added to clipboard!

Changing Column Data Type With SQL ALTER TABLE

Example 
ALTER TABLE Developers
ALTER COLUMN BirthDate year;
Related article