B.15 Content of SQL_INDEX_COLINF

SQL_INDEX_COLINF stores information related to indexed columns. Each row stores information on one indexed column.

The following table describes the content of SQL_INDEX_COLINF.

Table B‒17: Content of SQL_INDEX_COLINF
No.	Column name	Data type	Stored information
1	`TABLE_SCHEMA`	`VARCHAR(100)`	Schema name
2	`TABLE_NAME`	`VARCHAR(100)`	Table identifier of a table for which an index is defined
3	`INDEX_NAME`	`VARCHAR(100)`	Index identifier
4	`INDEX_ID`	`SMALLINT`	Index ID
5	`INDEX_ORDER`	`SMALLINT`	Order of the columns that comprise an index Stores the order of columns that comprise an index in ascending order, starting with `1`.
6	`COLUMN_NAME`	`VARCHAR(100)`	Indexed column name
7	`ASC_DESC`	`CHAR(1)`	Order of B-tree index key values `'A'` `ASC` is specified (the order is ascending). `'D'` `DESC` is specified (the order is descending). The null value is stored for indexes other than B-tree indexes.