mysql>
mysql> CREATE TABLE mytbl
-> (
-> i INT,
-> c CHAR(1)
-> );
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> SHOW INDEX FROM mytbl\G
Empty set (0.00 sec)
mysql>
mysql> drop table mytbl;
Query OK, 0 rows affected (0.00 sec)