how to use alter to change datatype code example Example: sql server alter column ALTER TABLE table_name ALTER COLUMN column_name new_data_type(size);