DROP AGGREGATE (Transact-SQL)
TOC
Collapse the table of content
Expand the table of content

DROP AGGREGATE (Transact-SQL)

 

Updated: October 28, 2015

THIS TOPIC APPLIES TO:yesSQL Server noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions


DROP AGGREGATE [ IF EXISTS ] [ schema_name . ] aggregate_name

IF EXISTS

Applies to: SQL Server (SQL Server 2016 Community Technology Preview 3.2 (CTP 3.2) 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.

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.

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.

The following example drops the aggregate Concatenate.

DROP AGGREGATE dbo.Concatenate;

Community Additions

ADD
Show:
© 2016 Microsoft