DB2 Universal Database for iSeries SQL Reference

SYSINDEXES

The SYSINDEXES view contains one row for every index in the SQL schema created using the SQL CREATE INDEX statement, including indexes on the SQL catalog. The following table describes the columns in the SYSINDEXES view:

Table 115. SYSINDEXES view

Column Name System Column Name Data Type Description
INDEX_NAME NAME VARCHAR(128) Name of the index. This will be the SQL index name if one exists; otherwise, it will be the system index name.
INDEX_OWNER CREATOR VARCHAR(128) Owner of the index
TABLE_NAME TBNAME VARCHAR(128) Name of the table on which the index is defined. This will be the SQL table name if one exists; otherwise, it will be the system table name.
TABLE_OWNER TBCREATOR VARCHAR(128) Owner of the table
TABLE_SCHEMA TBDBNAME VARCHAR(128) Name of the SQL schema that contains the table on which the index is defined
IS_UNIQUE UNIQUERULE CHAR(1) If the index is unique:

D
No (duplicates are allowed)

V
Yes (duplicate NULL values are allowed)

U
Yes

E
Encoded vector index
COLUMN_COUNT COLCOUNT INTEGER Number of columns in the key
INDEX_SCHEMA DBNAME VARCHAR(128) Name of the SQL schema that contains the index
SYSTEM_INDEX_NAME SYS_IXNAME CHAR(10) System index name
SYSTEM_INDEX_SCHEMA SYS_IDNAME CHAR(10) System index schema name
SYSTEM_TABLE_NAME SYS_TNAME CHAR(10) System table name
SYSTEM_TABLE_SCHEMA SYS_DNAME CHAR(10) System table schema name
LONG_COMMENT REMARKS VARCHAR(2000)

Nullable
A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

IASP_NUMBER IASPNUMBER SMALLINT Specifies the independent auxiliary storage pool (IASP) number.
INDEX_TEXT LABEL CHAR(50)
A character string supplied with the LABEL statement.
IS_SPANNING_INDEX SPANNING VARCHAR(3)
Indicates whether the index is partitioned:

NO
The index is partitioned.

YES
The index is not partitioned.

Contains the null value if the base table is not a partitioned table.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]