RDB/VMS Relational Database Operator DELETE_STORAGE_MAP — VMS RDB_4.0B
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. However, you can delete the relation once the necessary views and constraints have been deleted and the underlying storage map will be deleted with the relation and its data. 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.