SQL$HELP_OLD72.HLB  —  DROP  STORAGE_MAP, 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>
Close Help