DBPROP_INDEX_NULLS
Property group: Index
Property set: DBPROPSET_INDEX
Type: VT_I4
Typical R/W: R/W
Description: NULL Keys
Indicates whether NULL keys are allowed. One of the following values:
DBPROPVAL_IN_DISALLOWNULL ? The index does not allow entries where the key columns are NULL. If the consumer attempts to insert an index entry with a NULL key, the provider returns an error.
DBPROPVAL_IN_IGNORENULL ? The index does not insert entries containing NULL keys. If the consumer attempts to insert an index entry with a NULL key, the provider ignores that entry and no error code is returned.
DBPROPVAL_IN_IGNOREANYNULL ? The index does not insert entries where some column key has a NULL value. For an index having a multicolumn search key, if the consumer inserts an index entry with NULL value in some column of the search key, the provider ignores that entry and no error code is returned.
DBPROPVAL_IN_ALLOWNULL ? The index allows entries where the key columns are NULL and sorts according to the collation described by DBPROP_INDEX_NULLCOLLATION.