mysql-test/suite/innodb/include/innodb_dict.inc
raw| 1 | SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN |
| 2 | FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i |
| 3 | INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; |
| 4 | |
| 5 | SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i |
| 6 | INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID; |
| 7 | |
| 8 | SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i |
| 9 | INNER JOIN sys_foreign sf ON i.ID = sf.ID; |