Introducing PopSQL + dbt. The first SQL editor with built-in dbt support.Read more →

How to Rename a Table in Redshift

Redshift allows renaming a table using the ALTER TABLE syntax:

ALTER TABLE old_table_name RENAME TO new_table_name;

Ready for a modern SQL editor?