Using WinMySQL Professional

Drop index

Only accessible when connected and when a table is active, the «Table management>Drop index» submenu allows to delete any index on a column (excepted an index called «PRIMARY» corresponding to the primary key which only can be dropped with the «Table management>Drop primary key» submenu).

How to drop an index from a column ?

Invoke the «Table management>Drop index» submenu clicking on it or using the «Ctrl-F9» shortcut. Then, the «Indexes list» screen appears. Select the index you wish to get off and click on the «Drop index» button. To complete the operation, confirm your choice.