Using WinMySQL Professional

Delete table

Only accessible when connected and when a table is active, the «Table management>Delete» submenu allows a DBA to drop the active MySQL® table with all its data. This operation is very destructive because it annihilates a part of the current database with no way to cancel.

Then, you must be sure before using this feature (you must have enough privileges to do that). Anyway, to reduce important risk of server destruction, this feature is disabled when the current database is «mysql» : indeed, if you drop a table in this database, all the server may be unrecoverably unstable ; so WinMySQL Professional doesn't allow this action thru its menus on «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 delete the current table, just click on the «Table management>Delete» submenu.