You can execute the RENAME TABLE statement to rename a table.

Syntax

RENAME TABLE
    tbl_name TO new_tbl_name

Usage notes

  • PolarDB-X does not allow you to rename multiple tables at a time by using this statement.
  • This statement cannot be executed for tables that use global secondary indexes. This ensures system performance and stability.
  • You cannot execute this statement to rename only index tables. For information about how to rename index tables, see the description about the RENAME INDEX statement in the ALTER TABLE topic.