DROP PROCEDURE

Name

DROP PROCEDURE -- drop a stored procedure

Synopsis

DROP PROCEDURE name;

Description

DROP PROCEDURE is used to drop a stand-alone stored procedure in SPL

Parameters

name

the name of the procedure to be dropped.

Notes

To create a stored procedure use the CREATE PROCEDURE command.

Examples

The following drops the simple_procedure stored procedure that we created in the CREATE PROCEDURE section:

DROP PROCEDURE simple_procedure;