TIndexDef.Options Property

Describes the characteristics of the index.

Pascal

property Options: TIndexOptions;

C++

__property TIndexOptions Options;

Description

When creating a new index, use Options to specify the attributes of the index. Options can contain zero or more of the TIndexOption constants ixPrimary, ixUnique, ixDescending, ixCaseInsensitive, and ixExpression.

When inspecting the definitions of existing indexes, read Options to determine the option(s) used to create the index.

Note: Different database drivers may support only a subset of these options. For example, with dBASE tables, ixCaseInsensitive is not supported. Including an option that is not valid for a table will raise an exception.

Note: Primary indexes are, by definition unique. If setting the Options value ixPrimary, you need not also use ixUnique.