Last modified: January 09, 2012
Applies to: Windows | Windows Server
The JetDeleteIndex function deletes an index from a table.
JET_ERR JET_API JetDeleteIndex( __in JET_SESID sesid, __in JET_TABLEID tableid, __in JET_PCSTR szIndexName );
The database session context to use for the API call.
The table that contains the column that is to be deleted.
The name of the index to be deleted.
This function returns the JET_ERR datatype with one of the following return codes. For more information about the possible ESE errors, see Extensible Storage Engine Errors and Error Handling Parameters.
The operation completed successfully.
An attempt was made to delete an index from a fixed table (for example, one created with JET_bitTableCreateFixedDDL).
An attempt was made to delete an index from a template table. A template table has fixed DDL.
The index named in szIndexName was not found.
The table cannot be updated because it was opened read-only.
Multiple threads attempted to use the same database session.
The transaction was opened as a read-only transaction.
When successful, the index is deleted and therefore cannot be used subsequently. There must not be any active transaction using the index.
On success, the currency is set before the first record.
Requires Windows Vista, Windows XP, or Windows 2000 Professional.
Requires Windows Server 2008, Windows Server 2003, or Windows 2000 Server.
Declared in Esent.h.
Implemented as JetDeleteIndexW (Unicode) and JetDeleteIndexA (ANSI).