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.
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
Equivalent Oracle command: