Using WinMySQL Professional

Delete column

Only accessible when connected and when a table is active, the «Table management>Delete column» submenu allows a table alteration with a column deletion. The user who wants to perform this operation must have, at least the «Can ALTER» privilege. This feature is dangerous because it destroys all data contained in the column which must be get off.

WinMySQL Professional disables this menu when the active database is «mysql» to prevent any table alteration which may lead to an unrecoverable crash of the MySQL® server.

How to delete a column ?

To modify a column, invoke the «Table management>Delete column» submenu by clicking on it or by using the «Ctrl-F5» shortcut. Then, the column list of the current table appears. Select which you want to process and click on the «Select» button and confirm your choice.