DELETE INDEX

version 11

DELETE INDEX (fieldPtr | indexName{; *})

The DELETE INDEX command is used to delete 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. If the field is included in one or more composite indexes, they will also be deleted.

• If you pass the name of an index (indexName), only the designated index will be deleted. This can consist of keyword indexes or standard indexes. If the field contains other indexes or belongs to other composite indexes, they will not be deleted.

The optional * parameter, when it is passed, is used to carry out the 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.

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")   

CREATE INDEX, SET INDEX.