Timescale+PopSQL - Run 100ms PostgreSQL queries on billions of rows. Click to learn more

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;
database icon
Finally, a unified workspace for your SQL development
Get more done, together, with PopSQL and Redshift