DROP FUNCTION

DROP FUNCTION — remove a user defined function

Syntax

DROP FUNCTION [schema.]func_name[/num_arg] IF EXISTS
DROP FUNCTION IF EXISTS [schema.]func_name[/num_arg]

Description

DROP FUNCTION removes the definition of an existing function. If schema_name is not specified, an attempt will be made to drop a function with the specified func_name from the current schema. To execute this command the user must be the owner of the function. See CREATE FUNCTION to create a function.

Parameters

Examples