Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

Format

More

Example

map-name

RDB/VMS Relational Database Operator DELETE_STORAGE_MAP — VMS RDB_4.0

 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:

FormatMoreExample

Format

 DELETE STORAGE MAP ──────────────> map-name ─────────────> .

Additional information available:

map-name

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.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026