DROP Processes for DROP MACRO
The system pursues the following process to drop a macro:
1 Sets an EXCLUSIVE lock on the macro.
2 Frees the disk space used by the dropped macro and any fallback copy.
3 Removes any explicit access privileges on the object.
4 Removes the metadata for the dropped object from the data dictionary.