SQL Reference

SYSCAT.INDEXCOLUSE

Lists all columns that participate in an index.


Table 65. SYSCAT.INDEXCOLUSE Catalog View
Column Name Data Type Nullable Description
INDSCHEMA VARCHAR(128)
Qualified name of the index.
INDNAME VARCHAR(18)
COLNAME VARCHAR(128)
Name of the column.
COLSEQ SMALLINT
Numeric position of the column in the index (initial position = 1).
COLORDER CHAR(1)
Order of the values in this column in the index. Values:

A = Ascending

D = Descending

I = INCLUDE column(ordering ignored)


[ Top of Page | Previous Page | Next Page ]