4D v13.4
DELETE INDEX
- 4D Language Reference
-
- Structure Access
-
- Structure Access Commands
- CREATE INDEX
- DELETE INDEX
- Field
- Field name
- Get external data pathNew
- GET FIELD ENTRY PROPERTIES
- GET FIELD PROPERTIES
- Get last field number
- Get last table number
- GET MISSING TABLE NAMES
- GET RELATION PROPERTIES
- GET TABLE PROPERTIES
- Is field number valid
- Is table number valid
- REGENERATE MISSING TABLE
- RELOAD EXTERNAL DATANew
- SET EXTERNAL DATA PATHNew
- SET INDEX
- Table
- Table name
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 | |||||
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.
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")
Product: 4D
Theme: Structure Access
Number:
967
Created: 4D v11 SQL
