INDEX_COLUMN_USAGE

Information on the columns in the indexes belonging to the current authorization identifier.

Column name	Data type	Contents
INDEX_CATALOG	CHAR (18)	Database name
INDEX_SCHEMA	CHAR (31)	Name of the schema to which the index belongs
INDEX_NAME	CHAR (18)	Name of the index
TABLE_NAME	CHAR (31)	Name of the base table to which the index belongs
COLUMN_NAME	CHAR (31)	Name of the column in the index
ORDINAL_POSITION	SMALLINT	Position of the column in the index
LENGTH_C	SMALLINT	Indicates the length (in bytes) to which the column is included in the index
INDEX_DISTANCE	SMALLINT	Distance of the column to the index start
DATE_TYPE_C	VARCHAR (24)	Data type of the column CHARACTER CHARACTER VARYING NATIONAL CHAR NATIONAL CHAR VARYING REAL DOUBLE PRECISION FLOAT INTEGER SMALLINT NUMERIC DECIMAL DATE TIME TIMESTAMP OLDEST

Table 75: INDEX_COLUMN_USAGE view of the INFORMATION_SCHEMA