RDB/VMS Relational Database Operator DELETE_STORAGE_MAP — VMS RDB_4.2
Deletes a storage map. You cannot delete a storage map for a relation that has data in it. If you attempt to do so, you will receive an error message. Example: RDO> DELETE STORAGE MAP DEGREES_MAP.
Additional information available:
Format
DELETE STORAGE MAP ──────────────> map-name ─────────────> .
Additional information available:
map-name
The name of the storage map definition you want to delete.
More
To use the DELETE STORAGE MAP statement to delete a storage map for a relation, you must have the Rdb/VMS DELETE privilege to the relation. You cannot delete a storage map that refers to a relation that contains data. If you attempt to do so, you will receive an error message. If a relation is deleted, the underlying storage map is also deleted. 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 STORAGE MAP statement.
Example
The following example deletes the storage map TEST_MAP: RDO> DELETE STORAGE MAP TEST_MAP.