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 [ 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.

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