Inherits properties from ISchemaElement and defines the properties listed in the following table.

Table 1. Multi-tenant Maintenance and Table Partition IIndex interface properties
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.