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
(B)0[m[1;4mDROP[m[1m [1;4mSTORAGE[m[1m [1;4mMAP[m[1m qq> <map-name> qqwqqqqqqqqqqqqqqwq>[m [1m [m [1m mq> [1;4mIF[m[1m [1;4mEXISTS[m[1m qj [m [1m [m [1m [m [1m [m [1m [m
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>