How to Rename a Table in Redshift
Last updated July 25, 2026 · By the SaturnSQL team
Use ALTER TABLE ... RENAME TO. Regular views bound to the table keep working, but late-binding views and application queries that use the old name will break at query time.
ALTER TABLE orders RENAME TO customer_orders;Move to another schema
ALTER TABLE public.orders SET SCHEMA archive;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