RENAME TABLE

Function

RENAME TABLE renames a specified table.

Precautions

RENAME TABLE has the same function as the following command:

Syntax

1
2

RENAME TABLE
{[schema.]table_name TO new_table_name} [, ...];

Parameters

• schema

  Specifies the schema name.

• table_name

  Specifies the name of the table to be modified.

• new_table_name

  Specifies the new table name.

Examples

Rename a table:

1

RENAME TABLE customer_address TO new_customer_address;

Helpful Links

CREATE TABLE, ALTER TABLE, and DROP TABLE