DROP AGGREGATE (Transact-SQL)

Article
12/29/2022

Applies to: SQL Server Azure SQL Managed Instance

Removes a user-defined aggregate function from the current database. User-defined aggregate functions are created by using CREATE AGGREGATE.

Transact-SQL syntax conventions

Syntax

DROP AGGREGATE [ IF EXISTS ] [ schema_name . ] aggregate_name

Note

To view Transact-SQL syntax for SQL Server 2014 (12.x) and earlier versions, see Previous versions documentation.

Arguments

IF EXISTS
Applies to: SQL Server ( SQL Server 2016 (13.x) through current version).

Conditionally drops the aggregate only if it already exists.

schema_name
Is the name of the schema to which the user-defined aggregate function belongs.

aggregate_name
Is the name of the user-defined aggregate function you want to drop.

Remarks

DROP AGGREGATE does not execute if there are any views, functions, or stored procedures created with schema binding that reference the user-defined aggregate function you want to drop.

Permissions

To execute DROP AGGREGATE, at a minimum, a user must have ALTER permission on the schema to which the user-defined aggregate belongs, or CONTROL permission on the aggregate.

Examples

The following example drops the aggregate Concatenate.

DROP AGGREGATE dbo.Concatenate;