You can execute the RENAME TABLE statement to rename a 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
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_namestatement.