Paavo Doe Paavo Doe - 3 months ago 11
MySQL Question

Scandinavian letter error, drop index from table?

How to DROP INDEX from entire table at mysql ?



My code:

DROP INDEX
päättä
ON data



As result I get error:

#1091 - Can't DROP 'päättä'; check that column/key exists


Solution would be remove all indexes from entire table ?

Does Mysql have it's own letters for Ä and Ö.

Answer

@Paavo Doe You can get the indexes with

SHOW INDEX FROM `table`

You can drop more than one index in one query, e.g.

ALTER TABLE table DROP INDEX first, DROP INDEX second, DROP INDEX third

if you want delete indexing from entire database these link will help you: [Delete all indexes of specific database OR [How can I drop all indexes in a SQL database with one command?