DROP PROCEDURE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP PROCEDURE statement removes a database procedure definition from the database. Sessions that are executing the procedure are allowed to complete before the procedure's query plan is removed from memory.
If a procedure that is executed from another procedure is removed, the calling procedure is retained but marked dormant, and cannot be executed until the called procedure is restored.
Note: Notes:
• DROP PROCEDURE cannot be prepared.
• Dropping a table procedure will cause dependent views to be dropped. To avoid the loss of dependent views when redefining a database procedure, use the syntax CREATE OR REPLACE PROCEDURE.