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:
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:
|
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:
Contains the null value if the base table is not a partitioned table. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.