ALTER RENAME TABLE

Function

This command is used to rename an existing table.

Syntax

ALTER TABLE oldTableName RENAME TO newTableName

Parameter Description

Examples

alter table h0 rename to h0_1;

System Response

The table name is changed. You can run the SHOW TABLES command to display the new table name.