SQL Index Definition Fields

Field 1 - Index Name

Identifies the name of the index as it must be shown in an SQL query. Case is significant. Refer to the topic Naming Tables, Columns and Indexes.

Field 2 - Created by SQL (Y/N)

Y Indicates that the index was created by an SQL Create-Index command.

N Indicates that the index was initially derived from a Reality file index.

Field 3 - Index Type

0 System use.

2 Item-id index.

3 Ordinary Reality index (sorted index).

Field 4 - Allow duplicates

Y Allows multiple rows per column to have the same value.

N Disallows multiple rows per column from having the same value.

Field 5 - Column name(s)

Lists the columns that are indexed.

Field 6 - Collation(s)

References field 5, indicating whether each column is indexed in Ascending or Descending order.

Field 7 - Reality index name

Specifies the name of the underlying Reality index.