SQL RENAME Table

The RENAME TABLE statement is used to change the table name.

Syntax: RENAME tableName TO newTableName;

We can also use the ALTER TABLE statement to change the table name.

Syntax: ALTER tableName   RENAME TO newTableName;  

Example:

RENAME EMPLOYEE1 TO EMPLOYEE2;   Or   ALTER EMPLOYEE1 RENAME TO EMPLOYEE2;

Example:

Statement processed.