Krishna: > Just check it up that any active transaction is still there in innodb > internal data dictionary.
Acutally I figured it out. There was a constraint on that column as well. Once I dropped the constraint, I was able to drop the index. Thanks for the help, Neil -- Neil Aggarwal, (281)846-8957, http://UnmeteredVPS.net/mysql MySQL pre-installed on a virtual private server for $25/mo Unmetered bandwidth = no overage charges, 7 day free trial -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org