DB2 Universal Database for iSeries SQL Reference

SYSKEYS

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:

Table 119. 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:

A
Ascending

D
Descending
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


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