SELECT i.NAME,i.POS,i.MTYPE,i.PRTYPE,i.LEN FROM INFORMATION_SCHEMA.INNODB_SYS_COLUMNS i INNER JOIN sys_tables st ON i.TABLE_ID=st.TABLE_ID; SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_SYS_FIELDS i INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID; SELECT i.* FROM INFORMATION_SCHEMA.INNODB_SYS_FOREIGN_COLS i INNER JOIN sys_foreign sf ON i.ID = sf.ID;
Name | Type | Size | Permission | Actions |
---|---|---|---|---|
checksum_not_strict.inc | File | 151 B | 0644 |
|
import.inc | File | 1014 B | 0644 |
|
innodb_dict.inc | File | 371 B | 0644 |
|
innodb_stats.inc | File | 665 B | 0644 |
|
innodb_stats_table_flag.inc | File | 2.33 KB | 0644 |
|
innodb_stats_table_flag_analyze.inc | File | 508 B | 0644 |
|