INDEXES

Information on the indexes belonging to the current authorization identifier. The current authorization identifier must have the UTILITY privilege for the database or must own the schema in which the index is defined.

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
SPACE_NAME	CHAR (18)	Name of the space in which the index is stored
LENGTH_I	SMALLINT	Total length of the index
CONSTRAINT_NAME	CHAR (31)	Name of the UNIQUE constraint if the index is used by a UNIQUE constraint. NULL value in all other cases
STATE	VARCHAR (9)	Status: GENERATED DEFECT
GENERATE_TYPE	VARCHAR (8)	as generated: EXPLICIT IMPLICIT
STATISTICS_INFO	VARCHAR (3)	YES Statistics information exists NO Statistics information does not exist
INDEX_TYPE	VARCHAR (8)	Index type: SINGLE COMPOUND

Table 74: INDEXES view of the INFORMATION_SCHEMA