From: Daevid Vincent
Date: March 29 2004 8:50pm
Subject: Drop all keys / indexes on a table?
List-Archive: http://lists.mysql.com/mysql/162697
Message-Id: <200403292053.i2TKrrW3025066@localhost.localdomain>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit

It has come to my attention that we have maxed out our keys due to a stupid
update script bug. It seemst that we've not been explicitly naming our keys
and therefore mysql tried to be helpful and adds a new key each time!
*sigh*.

Is there a SQL command to DROP ALL keys on a table, so I can just ALTER it
and add them specifically again?

http://daevid.com