DROP AGGREGATE

Drop a user-defined aggregate function

Syntax
      DROP AGGREGATE [ schema_name . ] aggregate_name

If the aggregate function is still referenced by any views, functions, or stored procedures (created with schema binding) then the attempt to drop will fail.

Minimum permissions: ALTER permission on the schema, or CONTROL permission on the aggregate.

Example

DROP AGGREGATE dbo.myAggregate

"Do you feel you've learnt by your mistakes here?
I think I have, yes, and I think I can probably repeat them almost
perfectly. I know my mistakes inside out" ~ Peter Cook and Dudley Moore

Related commands:

CREATE AGGREGATE

Equivalent Oracle command:

DROP FUNCTION