TIndexOptions type

Top

Describes the attributes of an index.

Unit
Db

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

Description
TIndexOptions is a set of attributes that applies to a specific index. A TIndexOptions value can include none or some of the following values:

Value	Meaning
ixPrimary	The index is the primary index of the table.
ixUnique	Each value in the index is unique; there are no duplicates.
ixDescending	The index imposes a descending sort order.
ixCaseInsensitive	The index sorts records case insensitively.