Alias (O)

The short name for the index.

Allow Reverse Scan (O)

A TRUE or FALSE value.

Applies to the DB2/UDB platform only.

TRUE — Indicates that the index is built with a backward page reference in addition to a forward page reference allowing the ability to read the index backwards.

Cluster (O)

A TRUE or FALSE value.

Applies to the DB2/UDB platform only.

TRUE — The table is clustered on this index (for example, the rows are physically stored in the order of the index columns).

Cluster 2 (O)

A TRUE or FALSE value.

This property applies to the MSSql platform and is applicable to unique indexes only.

TRUE — All other indexes have this cluster key appended to them.

Name (R)

The unique name.

Number of Unique Columns (S)

If this value is populated then this equals the number of columns that participate in the uniqueness constraint.

The columns that do not participate in the uniqueness constraint have the Include Only property set to TRUE. In such a case, the number of columns in the index is more than this (Number of Unique Columns) value.

Applies to the DB2/UDB platform and is applicable to unique indexes only.

Type (O)

A description of the index.

Valid values are Primary Key, User Key, Extension, and System.

Unique (O)

A TRUE or FALSE value.

A unique index prevents multiple rows with the same values in each of the index columns.

TRUE — Indicates that this index is unique

User Name (R)

The user-friendly name for the index.

User Primary Key (O)

A TRUE or FALSE value.

Property is used by the Siebel Enterprise Integration Manager (EIM).

TRUE — EIM enforces uniqueness on this index.