DELETE.INDEX

The DELETE.INDEX command deletes an alternate key index.

Format

DELETE.INDEX file.name field(s)

to delete specific indices

DELETE.INDEX file.name ALL

to delete all indices

where

file.name

is the VOC name of the file holding the indices.

field(s)

are the names of indexed fields to be deleted. The casing of the name used in the command must match that of the actual index name.

The DELETE.INDEX command deletes the named indices. Once an index has been deleted, any queries against the named field(s) may require processing of the entire file to locate records.

Example

DELETE.INDEX ORDERS DATE

This command deletes the index on the DATE field of the ORDERS file.