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/[email protected]