The DROP DERBY AGGREGATE statement removes a user-defined aggregate (UDA) that was created using a CREATE DERBY AGGREGATE statement.
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.
DROP DERBY AGGREGATE mode RESTRICT;