How to Drop a Column in Redshift
Dropping a column in Redshift involves using the ALTER TABLE
command. The typical syntax is as follows:
ALTER TABLE table_name DROP COLUMN column_name;
--The COLUMN keyword is actually optional
ALTER TABLE table_name DROP column_name;
Previous
How to Add a ColumnFinally, a unified workspace for your SQL development
Get more done, together, with PopSQL and Redshift