To change the records type of a column, you use the ALTER TABLE assertion as follows:

BY Best Interview Question ON 17 Jun 2020

Example

ALTER TABLE users
ALTER COLUMN username[SET DATA] TYPE new_data_type;