The DBPROPSET_INDEX property set contains the following properties. All of these properties are in the Index property group.
Property ID
Description
DBPROP_INDEX_AUTOUPDATE
Type: VT_BOOL
Typical R/W: R only
Description: Auto Update
Notes: For this provider, the value is always VARIANT_TRUE, which indicates that the index is automatically maintained.
DBPROP_INDEX_NULLCOLLATION
Type: VT_I4
Typical R/W: R only
Description: NULL Collation
Notes: Specifies how null values are collated in the index. For this provider, the value is always DBPROPVAL_NC_LOW, which indicates that null values are collated at the low end of the list.
DBPROP_INDEX_NULLS
Type: VT_I4
Typical R/W: R/W
Description: NULL Keys
Notes: Specifies whether null keys are allowed. For this provider, the value is always DBPROPVAL_IN_DISALLOWNULL, which indicates that the index does not allow entries where the key columns are NULL. If you try to insert an index entry with a null key, the provider returns an error. This provider supports indexes that are nullable and indexes where null values are disallowed.
DBPROP_INDEX_TYPE
Type: VT_I4
Typical R/W: R only
Description: Index Type
Notes: Specifies the type of the index.For this provider, the value is always DBPROPVAL_IT_BTREE.
DBPROP_INDEX_UNIQUE
Type: VT_BOOL
Typical R/W: R/W
Description: Unique
Notes: Specifies whether index keys must be unique. The provider supports the following values:
VARIANT_TRUE, which indicates that the index keys must be unique
VARIANT_FALSE, which indicates that duplicate keys are allowed.