# aggregateName

An aggregateName represents a user-defined aggregate (UDA). To create a UDA, use the CREATE DERBY AGGREGATE statement.

## Syntax

    [ schemaName. ] SQLIdentifier

You can qualify an aggregate name with a schemaName. If a qualified aggregate name is specified, the schema name cannot begin with SYS.

## Example

    -- types.maxPrice is an aggregateName that includes a schemaName
    CREATE DERBY AGGREGATE types.maxPrice FOR PRICE
    EXTERNAL NAME 'com.example.myapp.types.PriceMaxer';

Parent topic: SQL identifiers