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.