Using WinMySQL Professional

Rename table

Only accessible when connected and when a table is active, the «Table management>Rename» submenu allows a DBA to change the name of the current table. So, a such operation could be dangerous for the MySQL® server if it is performed on the «mysql» database. ; then WinMySQL Professional disables this submenu when the current database is «mysql». If you really want to do it, connected to the «mysql» database , use the SQL pseudo terminal to manually perform the query (see the « Submenu File>New/Open SQL query» submenu).

To rename the current table, click on the «Table management>Rename» submenu, enter the new name in the databasename field and then, click on the «Rename button».