SHOW CREATE TABLE INFORMATION_SCHEMA.INNODB_SYS_INDEXES; Table Create Table INNODB_SYS_INDEXES CREATE TEMPORARY TABLE `INNODB_SYS_INDEXES` ( `INDEX_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `NAME` varchar(64) NOT NULL DEFAULT '', `TABLE_ID` bigint(21) unsigned NOT NULL DEFAULT 0, `TYPE` int(11) NOT NULL DEFAULT 0, `N_FIELDS` int(11) NOT NULL DEFAULT 0, `PAGE_NO` int(11) NOT NULL DEFAULT 0, `SPACE` int(11) NOT NULL DEFAULT 0, `MERGE_THRESHOLD` int(11) NOT NULL DEFAULT 0 ) ENGINE=MEMORY DEFAULT CHARSET=utf8