DELETE-INDEX

Deletes an index section previously generated by the CREATE-INDEX command.

Command Class

TCL-I command

Syntax

DELETE-INDEX file-name{,data-section} index-name

Syntax Elements

file-name The name of the file containing the index to be deleted.

data-section The name of the data section with which the index is associated. Must immediately follow file-name and be preceded by a comma. If omitted, the default data section is assumed.

index-name The name of the index to be deleted.

Restrictions

Requires SYS1 privileges.

Comments

If the index was created from an index definition, this remains in the file's dictionary. To remove the index definition, you must use the English command EDELETE with following syntax:

EDELETE DICT file-name 'index-name'

Ensure that you use the correct case for the index name and enclose it in single quotes.

See Indexing for more information on indexing.

Example

The following command deletes index GT200 of file SALESTAFF, but it does not delete the index definition for GT200.

:DELETE-INDEX SALESTAFF GT200

If there is an index definition for GT200, this can be deleted by entering:

:EDELETE DICT SALESTAFF 'GT200'

See Also

Indexing, DEFINE-INDEX, CREATE-INDEX, VERIFY-INDEX, EDELETE.