DROP Processes for DROP PROCEDURE
The system pursues the following process to drop a procedure.
1 Sets an EXCLUSIVE lock on the procedure.
2 Frees the disk space used by the dropped procedure 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.