Redshift Alter Table Drop Column
The RazorSQL alter table tool for Amazon AWS Redshift includes a Drop Column option for dropping a column from a Redshift table. The drop column function allows the user to select a column to drop from the table. The tool then generates the appropriate alter table drop column DDL command for dropping the column from the table.
Listed below is an example of the DDL generated by the Redshift Alter Table Drop Column tool:
ALTER TABLE sample.public.project DROP COLUMN plocation
Below is a screen shot of the drop column function of the Redshift alter table tool.
