Informix Guide to SQL: Syntax SQL Statements

Use the DROP AGGREGATE statement to drop a user-defined aggregate that you created with the CREATE AGGREGATE statement.

The support functions defined for a user-defined aggregate do not depend on the aggregate for their existence. When you drop a user-defined aggregate, you do not drop the support functions that you defined for the aggregate in the CREATE AGGREGATE statement.

The database server does not track dependency of SQL statements on user-defined aggregates that you use in the statements. For example, you can drop a user-defined aggregate that is used in an SPL routine.

In the following example, the user drops the aggregate named my_avg.

DROP AGGREGATE my_avg

Related statements: CREATE AGGREGATE

For information about how to invoke a user-defined aggregate, see the discussion of user-defined aggregates in the Expression segment.

For a description of the sysaggregates system catalog table that holds information about user-defined aggregates, see the Informix Guide to SQL: Reference.

For a discussion of user-defined aggregates, see Extending Informix Dynamic Server 2000.