; CREATE TABLE sys_indexes SELECT i.* FROM INFORMATION_SCHEMA.INNODB_INDEXES i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN FROM INFORMATION_SCHEMA.INNODB_COLUMNS i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID ORDER BY i.NAME,i.POS; NAME POS MTYPE PRTYPE LEN c0 0 0 0000 0 ct 0 0 00000000 00 