Skip to content

    TIndexOptions

    Set of TIndexOption values.

    Declaration

    Source position: db.pas line 1247

    type
  TIndexOptions = Set of TIndexOption = (ixPrimary,ixUnique,ixDescending,ixCaseInsensitive,
                ixExpression,ixNonMaintained);

    Values

    Value Description
    ixPrimary The index is the primary index for the data.
    ixUnique The index is a unique index, i.e. each index value can occur only once.
    ixDescending The values in the index are sorted descending.
    ixCaseInsensitive The values in the index are sorted case-insensitively.
    ixExpression The values in the index are based on a calculated expression.
    ixNonMaintained The index is non-maintained, i.e. changing the data will not update the index.

    Description

    TIndexOptions contains the set of properties that an index can have. It is used in the TIndexDef.Options property to describe all properties of an index definition as in TIndexDef.

    See also

    Name Description
    TIndexDef.Options Index options.
    TIndexDef Index definition.
    TIndexOption Index description flags.