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