Updated on 2024-10-09 GMT+08:00

RENAME

Function

The ALTER TABLE ... RENAME command is used to change the table name.

Syntax

ALTER TABLE tableName RENAME TO newTableName

Parameter Description

Table 1 RENAME parameters

Parameter

Description

tableName

Table name.

newTableName

New table name.

Example

ALTER TABLE table1 RENAME TO table2

Response

You can run the SHOW TABLES command to view the new table name.