DROP PROCEDURE

Drop the specified procedure.

Syntax

DROP PROCEDURE [ IF EXISTS ] procedure-name

Description

Drops the specified procedure. This statement is valid only if there is exactly one procedure instance with the procedure-name in the schema. Include the IF EXISTS clause to execute the statement only if the specified procedure exists in GemFire XD.

The identified procedure can have any number of parameters defined for it. If no procedure with the indicated name in the named or implied schema, an error (SQLSTATE 42704) occurs. An error also occurs if more than one specific instance of the procedure exists in the named or implied schema.