Snowflake
Rename Tables

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


_10
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

_10
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

_10
ALTER TABLE emp_records RENAME TO employee_records;

Y42 SQL completion user interface

Your AI copilot for Snowflake SQL

Write production-ready SQL with AI-based suggestions.

Get Started