The DROP DERBY AGGREGATE statement removes a user-defined aggregate (UDA) that was created using a CREATE DERBY AGGREGATE statement.
DROP DERBY AGGREGATE [ schemaName. ] SQL92Identifier RESTRICT
The aggregate name is composed of an optional schemaName and a SQL92Identifier. If a schemaName is not provided, the current schema is the default schema. If a qualified aggregate name is specified, the schema name cannot begin with SYS.
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;