1  DELETE_INDEX
   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.
 

2  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

 

3  index-name
   The name of the index definition you want to delete.
 

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