Renames a table in the current database.
Syntax
RENAME TABLE TableName1 TO TableName2
Arguments
TableName1
Specifies the name of the table to be renamed.
TableName2
Specifies the new name of the table.
Remarks
You cannot use RENAME TABLE to change the name of a free table; use RENAME instead.