# SHOW AGGREGATES

Lists any existing user-defined aggregate functions (UDAF) in the specified database.

## Syntax

```
SHOW AGGREGATES [EXTENDED] [{FROM | IN} database_name] [LIKE pattern]

```

## Remarks

* You can use `SHOW AGGREGATES EXTENDED` to see detailed information about each UDAF in the specified database, including each of the UDFs that are executed for each step in the UDAF function body.
* Refer to the [Permissions Matrix](https://docs.singlestore.com/cloud/reference/sql-reference/security-management-commands/permissions-matrix.md) for the required permissions.

## Examples

**SHOW AGGREGATES in a Database**

The following example lists each UDAF function in the target database.

```sql
SHOW AGGREGATES in db1;

```

```output

+-------------------+
| Aggregates_in_db1 |
+-------------------+
| myaggregate       |
+-------------------+
1 row in set (0.00 sec)

```

**SHOW AGGREGATES EXTENDED**

The following example shows detailed information about each UDAF in the current database.

```sql
SHOW AGGREGATES EXTENDED \G;

```

```output

*** 1. row ***
Aggregates_in_db1: multiply_hundred
          Definer: root@localhost
 Argument type(s): bigint(20) NULL
       State type: bigint(20) NULL
      Return type: bigint(20) NULL
  Initialize with: multiply_hundred_init
     Iterate with: multiply_hundred_iter
       Merge with: multiply_hundred_merge
   Terminate with: multiply_hundred_terminate
1 row in set (0.00 sec)

```

**SHOW AGGREGATES LIKE**

The following example demonstrates how to find a specific UDAF in the target database.

```sql
SHOW AGGREGATES LIKE 'multiply%';

```

```output

+-------------------------------+
| Aggregates_in_db1 (multiply%) |
+-------------------------------+
| multiply_hundred              |
+-------------------------------+
1 row in set (0.00 sec)

```

**Related Topics**

* [CREATE AGGREGATE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/create-aggregate.md)
* [SHOW CREATE AGGREGATE](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/show-create-aggregate.md)

***

Modified at: May 22, 2023

Source: [/cloud/reference/sql-reference/procedural-sql-reference/show-aggregates/](https://docs.singlestore.com/cloud/reference/sql-reference/procedural-sql-reference/show-aggregates/)

(An index of the documentation is available at /llms.txt)