# DROP DERBY AGGREGATE statement

The DROP DERBY AGGREGATE statement removes the specified user-defined aggregate (UDA).

A UDA is created by a CREATE DERBY AGGREGATE statement.

## Syntax

    DROP DERBY AGGREGATE aggregateName RESTRICT

The RESTRICT keyword is required. CASCADE semantics are not supported. That is, Derby will not track down and drop orphaned objects.

Dropping a UDA implicitly drops all USAGE privileges that reference it. See GRANT statement and REVOKE statement for more information.

Derby raises an error if a trigger or view references the UDA.

## Example

    DROP DERBY AGGREGATE mode RESTRICT;

Parent topic: DROP statements
Related reference
DROP FUNCTION statement
DROP INDEX statement
DROP PROCEDURE statement
DROP ROLE statement
DROP SCHEMA statement
DROP SEQUENCE statement
DROP SYNONYM statement
DROP TABLE statement
DROP TRIGGER statement
DROP TYPE statement
DROP VIEW statement