Deletes the specified storage map definition.

1  –  Environment

    You can use the DROP STORAGE MAP statement:

    o  In interactive SQL

    o  Embedded in host language programs to be precompiled

    o  As part of a procedure in an SQL module

    o  In dynamic SQL as a statement to be dynamically executed

2  –  Format

  DROP STORAGE MAP --> <map-name> --+--------------+->
                                    +-> IF EXISTS -+

3  –  Arguments

3.1  –  IF_EXISTS

    Prevents SQL command language from displaying error messages if
    the referenced object does not exist in the database.

3.2  –  map-name

    Specifies the name of the storage map you want to delete.

4  –  Examples

    Example 1: Deleting a storage map in interactive SQL

    This example deletes a storage map. You cannot delete a storage
    map that refers to a table that contains data.

    SQL> ATTACH 'FILENAME mf_personnel';
    SQL> DROP STORAGE MAP WORK_STATUS_MAP;
    %RDB-E-NO_META_UPDATE, metadata update failed
    -RDMS-F-RELNOTEMPTY, relation WORK_STATUS has data in it
    SQL> DELETE FROM WORK_STATUS;
    3 rows deleted
    SQL> DROP STORAGE MAP WORK_STATUS_MAP;
    SQL>