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

Reply via email to