Here is an example to rename employee to employee_new: RENAME TABLE db_how_to.employee TO db_how_to.employee_new;