DROP FUNCTION

Drop a function.

Table of contents

Synopsis

DROP FUNCTION [ IF EXISTS ] function_name
    ( [ [ argument_name ] argument_type [, ...] ] )

Description

DROP FUNCTION drops a user-defined function. The function_name and respective arg_type variables must be specified.

Parameters

IF EXISTS

Do not produce an error if the function doesn’t exist.

function_name

The name of the function to drop.

argument_name

The name given to an argument.

Function arguments do not retain names, but you can name them in your query for documentation purposes. Note that DROP FUNCTION will ignore argument names, since only the argument data types are needed to identify the function.

argument_type

The data type of an argument, if any.