Using WinMySQL Professional

Drop primary key

Only accessible when connected and when a table is active, the «Table management>Drop primary key» submenu allows a table alteration with a primary key deletion. The user who wants to perform this operation must have, at least the «Can ALTER» privilege. 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. Be really careful because if the current table is «mysql», WinMySQL Professional allows to add primary keys (see «Table management>Add primary key» section) but denies to drop it. In a such case, you would be forced to use the SQL pseudo-terminal to correct manually the problem. See the «Submenu File>New SQL query» section.

How to drop a primary key ?

Just invoke the «Table management>Drop primary key» submenu clicking on it or using the «Ctrl-F7» shortcut.