Alter Table Statement in MySQL : How to Rename Table

In this article I will show you how to rename table in MySQL.

RENAME TABLE IN MYSQL

Syntax

Follow the syntax to rename a table in MySQL.

ALTER TABLE table_name
  RENAME TO new_table_name;

Where;

• table_name : Name of the table to rename.
• new_table_name : New table name to use.

Example

Let’s see how we can rename the table in MySQL using Alter Table Statement.

ALTER TABLE contacts
  RENAME TO people;

This ALTER TABLE example will rename the contacts table to people.