Drop an aggregate

The DROP AGGREGATE statement removes the definition of an aggregate from the database. You must be the owner of the aggregate or the database administrator (DBA) to drop its definition from the database.

If you are the owner or the DBA, the following statement removes the aggregate SUMSQ from the database:
DROP AGGREGATE SUMSQ;

Dropping an aggregate has no effect on functions that are associated with the aggregate. Use the DROP FUNCTION statement to remove a function from the database.