DROP AGGREGATE

Use the DROP AGGREGATE command to remove an existing user-defined aggregate function (UDAF). The usage is similar to DROP FUNCTION, except that it’s for aggregate functions.

Syntax

DROP AGGREGATE [ IF EXISTS ] function_name [ ( argument_type [, ...] ) ] ;

Parameter or clause	Description
function_name	Name of the UDAF you want to drop.
( argument_type [ , … ] )	Optional: Argument types of the function.Specify the argument types when the name of the function you want to drop isn’t unique within the schema.
IF EXISTS	Do not return an error if the specified function does not exist. A notice is issued in this case.

Usage

A function can be dropped using one of the following methods:

• Full function signature:

DROP AGGREGATE function_name ( argument_type [, ...] );

• Function name only, if it’s unique in its schema:

DROP AGGREGATE function_name;

You can run SHOW FUNCTIONS; to list all existing UDFs to see if a function name is unique.

See also

CREATE AGGREGATE

Create a user-defined aggregate function

DROP FUNCTIONS

Drop a user-defined function