This topic describes how to use the RENAME INDEX statement to rename a table.
RENAME TABLE tbl_name TO new_tbl_name
- PolarDB-XDRDS 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.