When I try to drop an index from an InnoDB table:
drop index company_n56 on company;
I get this error:
ERROR 1025 (HY000): Error on rename of './thymeleweb/#sql-788_1218' to
'./thymeleweb/company' (errno: 150)
Look at the index using: show keys from company\G
gives me this info for that key:
The field is a varchar field that holds the id of a record in
the person table:
When I look at the person table, I do not see an index that would
refer back to this table.
Any ideas why I can't drop this index?
Neil Aggarwal, (281)846-8957
MySQL pre-installed on a virtual private server for $25/mo
Unmetered bandwidth = no overage charges, 7 day free trial