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

Syntax

RENAME TABLE
    tbl_name TO new_tbl_name

You can execute the following statement to rename multiple tables at a time:

RENAME TABLE tb_a to tb_b, tb_c to tb_d

Usage notes

  • 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 index tables. To rename index tables, use the ALTER TABLE table_name RENAME INDEX old_index_name TO new_index_name statement.