DROP FUNCTION

Drop a function.

Table of Contents

Synopsis

  1. DROP FUNCTION [ IF EXISTS ] function_name
  2.     ( [ [ arg_name ] arg_type [, ...] ] )

Description

DROP FUNCTION drops a function. A function name and argument types 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.

arg_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.

arg_type:

The data type of an argument, if any.

See Data Types for more information about the supported types.