11 lines
455 B
SQL
11 lines
455 B
SQL
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;
|
|
|
|
SELECT si.NAME,i.POS,i.NAME FROM INFORMATION_SCHEMA.INNODB_FIELDS i
|
|
INNER JOIN sys_indexes si ON i.INDEX_ID=si.INDEX_ID ORDER BY si.NAME, i.POS;
|
|
|
|
--sorted_result
|
|
SELECT i.FOR_COL_NAME, i.REF_COL_NAME, i.POS FROM INFORMATION_SCHEMA.INNODB_FOREIGN_COLS i
|
|
INNER JOIN sys_foreign sf ON i.ID = sf.ID;
|