SQL - Rename Tables in the Database

Different databases support the different syntax to rename a table.

Use the following ALTER TABLE RENAME script to rename table names in the MySQL, PostgreSQL, and SQLite database.

SQL Script: Rename Table in MySQL, PostgreSQL, and SQLite

ALTER TABLE Employee RENAME TO Emp;

The following statement will rename Employee table to TempEmployee in the Oracle database.

SQL Script: Rename Table in Oracle

RENAME Employee TO TempEmployee;

Use the sp_rename built-in stored procedure to rename a table in the SQL Server database.

SQL Script: Rename Table in SQL Server

sp_rename Employee, emp;

Note:

Make sure that the original table name is correct, and the new name has not been used with other database objects; otherwise, it will raise an error.