MySQL Rename Table
The RazorSQL alter table tool includes a Rename Table option for renaming an MySQL database table. The rename table option allows the user to type in a new name for the table being renamed. The tool then generates and can execute the SQL to rename the MySQL database table.
Listed below is an example of the SQL generated by the MySQL Rename Table function:
ALTER TABLE sample.employee RENAME TO employee_new
Below is a screen shot of the rename table function of the MySQL alter table tool.