DROP AGGREGATE (Transact-SQL)
Removes a user-defined aggregate function from the current database. User-defined aggregate functions are created by using CREATE AGGREGATE.
.gif "Topic link icon")
Transact-SQL Syntax Conventions
Syntax
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.
DROP AGGREGATE dbo.Concatenate
See Also
Reference
CREATE AGGREGATE (Transact-SQL)
Other Resources
Creating User-defined Aggregates