title: MySQL dropping all indexes from table
body: <p>I have a MySQL database that runs for some time now with many changes on it. Lately I looked over it and I noticed that in some cases I have doubled the index on the same field. Some Indexes are missing, and in general there is a huge mess in all the indexes.</p>
  
  <p>I wants to drop all indexes from a table. Later on I have a prepared script that will run <code>ALTER TABLE</code> and add the relevant indexes.</p>
  
  <p>Is there a way to drop all indexes from a table?</p>