The SYSKEYS view contains one row for every column of an index in the SQL
schema, including the keys for the indexes on the SQL catalog. The
following table describes the columns in the SYSKEYS view:
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
INDEX_NAME | IXNAME | 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 | IXCREATOR | VARCHAR(128) | Owner of the index |
COLUMN_NAME | COLNAME | VARCHAR(128) | Name of the column of the key. This will be the SQL column name if one exists; otherwise, it will be the system column name. |
COLUMN_POSITION | COLNO | INTEGER | Numeric position of the column in the row |
ORDINAL_POSITION | COLSEQ | INTEGER | Numeric position of the column in the key |
ORDERING | ORDERING | CHAR(1) | Order of the column in the key:
|
INDEX_SCHEMA | IXDBNAME | VARCHAR(128) | Name of the schema containing the index. |
SYSTEM_COLUMN_NAME | SYS_CNAME | CHAR(10) | System name of the column |
SYSTEM_INDEX_NAME | SYS_IXNAME | CHAR(10) | System name of the index |
SYSTEM_INDEX_SCHEMA | SYS_IDNAME | CHAR(10) | System name of the schema containing the index |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.