DELETE.INDEX

DELETE.INDEX

Top  Previous  Next

 

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.nameis 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.

 

 

See also:

BUILD.INDEX, CREATE.INDEX, DISABLE.INDEX, LIST.INDEX, MAKE.INDEX, REBUILD.ALL.INDICES