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)
Nullable |
Indicates whether the index is partitioned:
Contains the null value if the base table is not a partitioned table. |
INDEX_DEFINER | DEFINER | VARCHAR(128) | Name of the user that defined the index. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.