Member Name

Description

Default

Use if no options are needed.

Unique

Create a unique index order.

Candidate

This creates a unique index order that prevents duplicate data. On ADT tables, it is the same as the ADS_UNIQUE option. This can be used with Visual FoxPro tables (ADS_VFP) to create an index that can be used as a primary key and in referential integrity relationships.

Compound

Create an index order (tag) within a compound index file. Note that this option is always set when the table type is TableType.ADT.

Descending

Create a descending index order.

Binary

Create a binary index. The index expression must have a logical result. This option cannot be combined with other options except for Compound.