DROP PROCEDURE v10

Name

DROP PROCEDURE -- remove a procedure.

Synopsis

DROP PROCEDURE <name>

Description

DROP PROCEDURE removes the definition of an existing procedure. To execute this command you must be a superuser or the owner of the procedure.

Parameters

name

The name (optionally schema-qualified) of an existing procedure.

Examples

The following command removes the select_emp procedure.

DROP PROCEDURE select_emp;

See Also

CREATE PROCEDURE, ALTER PROCEDURE