updating column datatype sql server code example Example: sql server alter column ALTER TABLE table_name ALTER COLUMN column_name new_data_type(size);