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

    Example:

    DELETE INDEX EMP_LAST_NAME.

1  –  More

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

    You cannot delete an index definition 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,
    Oracle Rdb starts a read/write transaction implicitly.

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

2  –  Format

  (B)0DELETE INDEX qqqwqqq> index-name qqqqwqq> .
                  mqqqq<qqq , qqqq<qqqqj

2.1  –  index-name

    The name of the index definition you want to delete.

3  –  Examples

    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.