Query to change the datatype of a table.

ALTER TABLE [table_name] ALTER COLUMN [column_name] [new_datatype]

ALTER TABLE Student ALTER COLUMN Name varchar