DROP TABLE IF EXISTS t9; CREATE TABLE t9(c1 INTEGER NOT NULL); DROP INDEX i1 ON t9; ERROR 42000: Can't DROP INDEX `i1`; check that it exists DROP TABLE t9; SHOW TABLES; Tables_in_test