DROP INDEX
DROP INDEX indexname
This statement will cause the named index to be deleted from its table. To dlete an word search index you must use DROP WORD INDEX.
Examples
DROP INDEX SL00test_A1
See also:
DROP TABLE, CREATE INDEX, DROP WORD INDEX