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

Example

                                        

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

Suggest An Answer