DROP DERBY AGGREGATE statement

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