mysql does rename of the table remove indexes code example
Example 1: rename table in mysql
RENAME TABLE old_table TO new_table;
Example 2: alert table name mysql
ALTER TABLE exampletable RENAME TO new_table_name;
RENAME TABLE old_table TO new_table;
ALTER TABLE exampletable RENAME TO new_table_name;