How to Rename a Column in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use ALTER TABLE ... RENAME COLUMN old TO new. It is a metadata-only change and takes effect immediately, but you cannot rename a column that a view depends on unless the view is late-binding.
ALTER TABLE orders RENAME COLUMN amount TO order_amount;If a regular view references the column, Redshift blocks the rename with a dependency error. Drop and recreate the view, or use views created WITH NO SCHEMA BINDING, which are only resolved at query time.
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