You can use a temporary table to change datatype without altering the original table.

• Create a new temporary table with the desired datatype

• Insert data from the original table into the temporary table

• D...read more