The DROP DBPROC[EDURE] statement (drop_dbproc_statement) deletes a database procedure.
SQL Tutorial, Database Procedures
If no schema is specified in the database procedure name, the current schema is assumed implicitly.
The current database user must be the owner of the database procedure or have the DROPIN privilege for the schema to which the database procedure is assigned.
The metadata for the database procedure is deleted.