Snowflake RENAME TABLE: How to Rename a Table in Snowflake

RENAME TABLE changes the name of an existing table in your database. The new name must not be already in use by another table, view, or other database object.

Syntax

ALTER TABLE `<existing_name>` RENAME TO `<new_table_name>`;

Common use cases

Updating table names for clarity: If the role of a table in your database has evolved, you might rename it to better reflect its current use

ALTER TABLE user_data RENAME TO customer_profiles;

Renaming table names for consistency: To maintain consistency in naming conventions after restructuring or integrating new data management practices

ALTER TABLE emp_records RENAME TO employee_records;

Your AI copilot for Snowflake SQL

Write production-ready SQL with AI-based suggestions.

Get Started