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 can 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.
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.
The DROP PROCEDURE statement has the following format:
[EXEC SQL] DROP PROCEDURE [IF EXISTS] proc_name;
IF EXISTS
Suppresses error reporting for the specified object if the object does not exist and the user matches the schema.
proc_name
Specifies the name of the procedure to be removed.
Embedded Usage
In an embedded DROP PROCEDURE statement, a host language variable cannot be used to represent proc_name.
Permissions
You must be the owner of the database procedure.
Related Statements
CREATE PROCEDURE
EXECUTE
GRANT (privilege)