DROP FUNCTION

Drop the specified function.

Syntax

DROP FUNCTION [ IF EXISTS ] function-name

Description

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

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