|
Property name
|
Data type
|
Access
|
Description
|
|
Description
|
CHARACTER
|
Read-only
|
Returns a description of the index.
|
|
Fields
|
IFIELDSET
|
Read-only
|
Returns a collection containing the fields in the index.
The set may not be in the order the fields are defined in the database. The IndexFields property must be used to get the correct order of the fields.
|
|
IActive
|
LOGICAL
|
Writeable
|
Returns TRUE if the index is active.
|
|
IsPrimary
|
LOGICAL
|
Writeable
|
Returns TRUE if the index is the primary index for the table.
|
|
IsUnique
|
LOGICAL
|
Writeable
|
Returns TRUE if the index is unique.
|
|
IsWordIndex
|
LOGICAL
|
Writeable
|
Returns TRUE if the index is a word index.
|
|
Table
|
ITable
|
Read-only
|
Returns the parent table of the index.
|
|
IsLocal
|
LOGICAL
|
Writeable
|
Returns TRUE if the index is local per partition. (Default = FALSE)
This property cannot be edited after the index is created.
|
|
IndexFields
|
IINDEXFIELDLIST
|
Read-only
|
Returns a list of the table's index fields. This list ensures that IIndexField elements are listed in the correct order.
|