RDB/VMS Relational Database Operator DELETE_INDEX — VMS CDD+_4.1A
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:
More
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.
Format
DELETE INDEX ───┬───> index-name ────┬──> . └────<─── , ────<────┘
Additional information available:
index-name
The name of the index definition you want to delete.
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.