DROP TABLE IF EXISTS t1,T1; CREATE TABLE t1 (a int); SELECT * from T1; a drop table t1; flush tables; CREATE TABLE t1 (a int) type=INNODB; SELECT * from T1; Can't open file: 'T1.InnoDB'. (errno: 1) drop table t1;