Drops the definition for the specified procedure from the Data Dictionary and from the containing database or user.
When you drop a procedure, the system frees the disk space used by the dropped procedure and any fallback copy, removes any explicit access privileges on the object, and removes the metadata for the dropped object from the data dictionary.
ANSI Compliance
DROP PROCEDURE is ANSI SQL:2011-compliant.
Required Privileges
You must have the appropriate DROP privilege on the specified procedure.