AWS Redshift Alter Table Change Column Type

The RazorSQL alter table tool includes a Change Column Type option for changing the data types of columns on AWS Redshift database tables. The change column type function allows the user to choose a new type, a new length, and a new scale if appropriate for the data type chosen. The tool then generates the appropriate alter table alter column DDL command for changing the data type of the column on the table.

Listed below is an example of the DDL generated by the Redshift Alter Table Change Column Type function:

ALTER TABLE sample.public.project ALTER COLUMN pname TYPE varchar(100)

Below is a screen shot of the change column type tool contained within the Redshift alter table tool.

Redshift Change Column Type