Deletes one or more index definitions.  When the DELETE INDEX
 statement executes, Rdb/VMS deletes the index definition from the
 physical database.  If you invoke the database using the PATHNAME
 qualifier, Rdb/VMS also deletes the index definition from the data
 dictionary.

 Example:

      DELETE INDEX EMP_LAST_NAME.

Additional information available:

MoreFormatExamples

 To delete an index for a relation, you need the Rdb/VMS DELETE
 privilege to the relation.

 You cannot delete an index definition when other users are attached
 to the database, or if there is a storage map that specifies the
 index in a PLACEMENT VIA clause.

 You must execute this statement in a read/write transaction.  If
 there is no active transaction and you issue this statement, Rdb/VMS
 starts a read/write transaction implicitly.

 Other users are allowed to be attached to the database when you issue
 the DELETE INDEX statement.

 DELETE INDEX ───┬───> index-name ────┬──> .
                 └────<─── , ────<────┘

Additional information available:

index-name

 The name of the index definition you want to delete.

 Example 1

 Delete a single index:

 RDO> INVOKE DATABASE PERSONNEL = PATHNAME "PERSONNEL"
 RDO> DELETE INDEX DEG_COLLEGE_CODE.
 RDO> COMMIT

 This statement deletes the index from the physical database and the
 definition from the data dictionary.


 Example 2

 Delete more than one index definition:

 RDO> INVOKE DATABASE PERSONNEL = PATHNAME "PERSONNEL"
 RDO> DELETE INDEX EMP_LAST_NAME, SH_EMPLOYEE_ID.
 RDO> COMMIT

 This statement deletes the indexes from the physical database and
 their definitions from the data dictionary.