Rename Tables

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.


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;

Y42 SQL completion user interface

Your AI copilot for Snowflake SQL

Write production-ready SQL with AI-based suggestions.

Start for free