 INT; ### files in MYSQL_DATA_DIR/test sys_foreign.ibd sys_indexes.ibd sys_tables.ibd t0p.ibd ### files in MYSQL_TMP_DIR/alt_dir/test t0.ibd t0c.ibd 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 