> For the complete documentation index, see [llms.txt](https://docs.deltastream.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.deltastream.io/reference/sql-syntax/command/list-functions.md).

# LIST FUNCTIONS

## Syntax <a href="#synopsis" id="synopsis"></a>

```sql
[ LIST | SHOW ] FUNCTIONS;
```

## Description

This command provides a list of [Function](/overview/core-concepts/function.md)s defined under the [Access Control](/overview/core-concepts/access-control.md#organiation).

Functions are visible only if the current [Access Control](/overview/core-concepts/access-control.md#role) has `USAGE` privileges on them.

## Examples

```sh
demodb.public/demostore# LIST FUNCTIONS;
+----------------------------+-------+--------------+------------------+--------------------+----------+-------------+-------------------------------+-------------------------------+
|  Signature                 |  Type |  Source Name |  Class Name      |  Egress Allow URIs |  Owner   |  Properties |  Created At                   |  Updated At                   |
+============================+=======+==============+==================+====================+==========+=============+===============================+===============================+
| my_func(a VARCHAR) VARCHAR | udf   | my_src       | demo.DSUpperCase |                    | sysadmin | {}          | 2024-06-06 03:35:52 +0000 UTC | 2024-06-06 03:35:52 +0000 UTC |
+----------------------------+-------+--------------+------------------+--------------------+----------+-------------+-------------------------------+-------------------------------+
```