This topic describes how to use the RENAME INDEX statement to rename a table.

Syntax

RENAME TABLE
    tbl_name TO new_tbl_name

Note

  • PolarDB-X 1.0 does not allow you to execute the RENAME TABLE statement to rename multiple tables at a time.
  • The system does not allow you to rename a table that contains a global secondary index for stability and performance considerations.
  • You cannot use only the RENAME INDEX statement to rename an index table. If you need to rename an index table, we recommend that you use the RENAME INDEX statement. For more information, see ALTER TABLE.