How to Add a Column in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use ALTER TABLE ... ADD COLUMN. Redshift allows only one ADD COLUMN per ALTER TABLE statement, so adding several columns takes several statements. Adding a column with a default does not rewrite the table.
ALTER TABLE orders ADD COLUMN discount NUMERIC(5,2) DEFAULT 0;Multiple columns need multiple statements
ALTER TABLE orders ADD COLUMN status VARCHAR(32);
ALTER TABLE orders ADD COLUMN updated_at TIMESTAMP;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free