DELETE INDEX
DELETE INDEX ( fieldPtr | indexName {; *} )
| Parameter | Type | Description | |
|---|---|---|---|
| fieldPtr | indexName | Pointer, String | → | Pointer to field whose indexes are to be deleted or Name of index to be deleted |
| * | Operator | → | If passed = asynchronous operation |
Description
The DELETE INDEX command deletes one or more existing indexes from the database.
You can pass either a pointer to a field or the name of an index in the parameter:
- If you pass a pointer to a field (fieldPtr), all the indexes associated with the field will be deleted. This can consist of keyword indexes or standard indexes. However, if the field is included in one or more composite indexes, they are not deleted (you must pass an index name).
- If you pass the name of an index (indexName), only the designated index will be deleted. This can consist of keyword indexes, standard indexes or composite indexes.
The optional * parameter, when it is passed, performs deindexing in asynchronous mode. In this mode, the original method continues its execution after the call from the command, regardless of whether or not the index deletion is finished.
If there is no index corresponding to fieldPtr or indexName, the command does nothing.
Note for deployment
Since this command modifies the database structure, it cannot be used in the context of a read-only packaged application (.4dc file installed in the Program Files folder or .4dz file).
Example
This example illustrates both syntaxes of the command:
//Deletion of all indexes related to the LastName field
DELETE INDEX(->[Customers]LastName)
//Deletion of index named “CityZip”
DELETE INDEX("CityZip")