Introduction

---

The SQL RENAME TABLE statement is used to rename a table.

Syntax

---

RENAME TABLE [IF EXISTS] table_reference
TO table_reference

Use the RENAME TABLE statement to rename a table. The statement below renames a table:

RENAME TABLE Employee
TO Employees

Please see the Renaming Tables topic for more information on renaming tables.