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.
|
|