8. SQL Statements : DROP PROCEDURE
 
Share this page                  
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.