4D v14.3

DELETE INDEX

Home

 
4D v14.3
DELETE INDEX

DELETE INDEX 


 

DELETE INDEX ( fieldPtr | indexName {; *} ) 
Parameter Type   Description
fieldPtr | indexName  Pointer, String in Pointer to field whose indexes are to be deleted or Name of index to be deleted
Operator in If passed = asynchronous operation

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.

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

 
PROPERTIES 

Product: 4D
Theme: Structure Access
Number: 967

 
HISTORY 

Created: 4D v11 SQL

 
SEE ALSO 

CREATE INDEX
PAUSE INDEXES
SET INDEX

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)