IIndexDefinition::DropIndex

OLE DB Programmer's Reference

Drops an index from the base table.

HRESULT DropIndex(    DBID   *pTableID,    DBID   *pIndexID);

Parameters

pTableID: [in]
A pointer to the DBID of the base table.
pIndexID: [in]
A pointer to the DBID of the index to drop. This must be an index on the table specified with pTableID. If pIndexId is a null pointer, all indexes for the table specified with pTableID are dropped.

Return Code

S_OK: The method succeeded, and the index has been dropped from the base table.
DB_S_ERRORSOCCURRED: pIndexID was a null pointer, at least one index was successfully dropped, but one or more indexes for the specified table could not be dropped. The consumer can determine the set of indexes not dropped through the INDEXES schema rowset.
E_FAIL: A provider-specific error occurred.
E_INVALIDARG: pTableID was a null pointer.
DB_E_ERRORSOCCURRED: pIndexID was a null pointer, but none of the indexes for the specified table could be dropped.
DB_E_INDEXINUSE: The specified index was in use.
DB_E_NOINDEX: The specified index does not exist in the current data store or did not apply to the specified table.
DB_E_NOTABLE: The specified table does not exist in the current data store.
DB_E_TABLEINUSE: The specified table was in use, and the provider could not drop the index with the table open.
DB_SEC_E_PERMISSIONDENIED: The consumer did not have sufficient permission to drop the index.

Comments

For partitioned indexes, a call to this method drops all partitions.

If IIndexDefinition::DropIndex returns any errors, the index is not dropped.

If pIndexID is a null pointer and one or more indexes for that table cannot be dropped, the processing continues to attempt to drop the remaining indexes for that table.

See Also