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

2  Format

 (B)0DELETE STORAGE MAP qqqqqqqqqqqqqq> map-name qqqqqqqqqqqqq> .

 

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

2  More
   To use the DELETE STORAGE MAP statement to delete a storage map
   for a relation, you must have the Oracle Rdb 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,
   Oracle Rdb starts a read/write transaction implicitly.

   Other users are allowed to be attached to the database when you
   issue the DELETE STORAGE MAP statement.
 

2  Example
   The following example deletes the storage map TEST_MAP:

   RDO>   DELETE STORAGE MAP TEST_MAP.