How to Drop a Column in PostgreSQL
Last updated July 24, 2026 · By the SaturnSQL team
Use ALTER TABLE ... DROP COLUMN. The column is hidden immediately and space is reclaimed lazily by later updates and vacuums. Add CASCADE to also drop dependent views.
ALTER TABLE orders DROP COLUMN IF EXISTS internal_notes;When views depend on it
ALTER TABLE orders DROP COLUMN internal_notes CASCADE; -- drops dependent views tooRun 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