This topic has not yet been rated - Rate this topic

DROP AGGREGATE (Transact-SQL)

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

Syntax

Copy


          

DROP AGGREGATE [ schema_name . ] aggregate_name

Arguments

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.

Copy

DROP AGGREGATE dbo.Concatenate

Reference

CREATE AGGREGATE (Transact-SQL)

Concepts

Create User-defined Aggregates

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Content Add

FAQ