How to Rename a Table in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
Use ALTER TABLE ... RENAME TO. The rename is instant metadata-only, but views and queries referencing the old name break, so update them in the same change.
ALTER TABLE orders RENAME TO customer_orders;Move to a different schema
RENAME TO also accepts a qualified name, which moves the table between schemas or databases.
ALTER TABLE analytics.public.orders RENAME TO analytics.archive.orders;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