How to Drop a Column in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
Use ALTER TABLE ... DROP COLUMN. The column disappears immediately for queries; the underlying storage is reclaimed in the background. Dependent views break, so check them first.
ALTER TABLE orders DROP COLUMN discount;Drop multiple columns
ALTER TABLE orders DROP COLUMN discount, internal_notes;If you only want the column hidden from consumers rather than deleted, create a view without it instead, which is reversible.
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