Purpose
Drops the definition for the specified macro from the dictionary.
The system frees the disk space used by the dropped macro and any fallback copy, removes any explicit access privileges on the object, and removes the metadata for the dropped object from the data dictionary.
Required Privileges
You must have the appropriate DROP privilege on the specified macro.