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

A UDA is created by a .

Syntax DROP DERBY AGGREGATE aggregateName RESTRICT

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

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

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

 Example DROP DERBY AGGREGATE mode RESTRICT;