alter column type

ALTER TABLE table_name

DROP COLUMN column_name; 

ALTER TABLE table_name

ADD column_name datatype; 

ALTER TABLE table_name

ALTER COLUMN column_name datatype;