How can I drop multiple primary keys in phpmyadmin tables?
mysql, phpmyadmin, sql
Solution
Just open up the `Structure` tab on your phpmyadmin table. After the structure description, there should be a `Indexes` section where you'll see all indexes, including your primary keys. There you'll be able to either modify or remove any primary key you may have defined.
---- EDIT ----
Problem
I am working with phpmyadmin.I created a table with one primary key and 5 fields. But now all the integer fields have turned into a primary key. I tried using drop command but it doesn't help. How can I remove all primary keys from the table?