How to Add a Column in Snowflake (ALTER TABLE)
Last updated July 24, 2026 · By the SaturnSQL team
Use ALTER TABLE ... ADD COLUMN with the column name and type. Existing rows get NULL (or the DEFAULT you specify). You can add several columns in one statement.
ALTER TABLE orders ADD COLUMN discount NUMBER(5,2);With a default, or several at once
A constant DEFAULT applies to existing and new rows. Separate multiple columns with commas.
ALTER TABLE orders ADD COLUMN
status VARCHAR DEFAULT 'pending',
updated_at TIMESTAMP_NTZ;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