How to change column data type in Redshift

BEGIN TRANSACTION;                                                       

ALTER TABLE schemaname.tablename RENAME TO tablename_old;               
CREATE TABLE schemaname.tablename (); --New definition                  
INSERT INTO schemaname.tablename SELECT * FROM schemaname.tablename_old;
DROP TABLE schemaname.tablename_old;                                   

END TRANSACTION;                                                         
See also  How to delete an SQS queue from AWS CLI