sql query to change data type of column code example
Example 1: sql change column types
ALTER TABLE table_name
ALTER COLUMN column_name datatype;
ALTER TABLE product
ALTER COLUMN description VARCHAR(250);
Example 2: sql server alter column
ALTER TABLE table_name
ALTER COLUMN column_name new_data_type(size);
Example 3: sql alter column
Changes the data type of a table’s column.
Example: In the ‘users’ table, make the column ‘incept_date’ into a
‘datetime’ type.
ALTER TABLE users
ALTER COLUMN incept_date datetime;