# SHOW FUNCTIONS

Lists any existing user-defined functions in the specified database, including user-defined scalar-valued functions (UDFs) and user-defined table-valued functions (TVFs).

## Syntax

```sql
SHOW FUNCTIONS [{FROM | IN} database_name] [LIKE pattern]

```

## Remarks

* The `SHOW FUNCTIONS` command can be used to list functions in the current database or in another database. The function list returns the name for each function and who is the function definer. To show user-defined aggregate functions (UDAFs), see [SHOW AGGREGATES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-aggregates.md). Use [SHOW PROCEDURES](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-procedures.md) to list stored procedures.
* The Data Format column can be one of: JSON or ROWDAT\_1.
* The Link column shows the Connection Link.
* When function overloading is enabled, the output of `SHOW FUNCTIONS` includes columns for a function's arguments and variant ID. For overloaded functions, the columns contain the arguments and variant IDs. For non-overloaded functions, the columns display NULL. Refer to [Overloaded Functions and Stored Procedures](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/overloaded-functions-and-stored-procedures.md) for more information.

## Example - List Functions

The following example lists each function in the current database.

```sql
SHOW FUNCTIONS;

```

```output

+---------------------+-----------------------+---------+-------------+----------------+-----------+
| Functions_in_testDB | Function Type         | Definer | Data Format | Runtime Type   | Link      |
+---------------------+-----------------------+---------+-------------+----------------+-----------+
| tvf_1               | Table Valued Function | root@%  |             | PSQL           |           |
| check_spacingExt    | User Defined Function | root@%  | JSON        | Remote Service | HTTP_link |
+---------------------+-----------------------+---------+-------------+----------------+-----------+

```

## Example - List Overloaded Functions

The following shows the output of `SHOW FUNCTIONS` with function overloading enabled. The functions in this output are the overloaded `print_type` functions from [Overloaded Functions and Stored Procedures](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/overloaded-functions-and-stored-procedures.md).

```sql
SHOW FUNCTIONS;

```

```output

+-------------------+-----------+-----------------------+------------+---------+-------------+--------------+------+---------+
| Functions_in_test | Arguments | Function Type         | Variant ID | Definer | Data Format | Runtime Type | Link | Options |
+-------------------+-----------+-----------------------+------------+---------+-------------+--------------+------+---------+
| print_type        | BIGINT    | User Defined Function |          1 | root@%  |             | PSQL         |      |         |
| print_type        | INT       | User Defined Function |          0 | root@%  |             | PSQL         |      |         |
+-------------------+-----------+-----------------------+------------+---------+-------------+--------------+------+---------+

```

## Related Topics

* [DROP FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/drop-function.md)
* [SHOW CREATE FUNCTION](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-create-function.md)
* [Overloaded Functions and Stored Procedures](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/overloaded-functions-and-stored-procedures.md)

***

Modified at: March 17, 2026

Source: [/db/v9.1/reference/sql-reference/procedural-sql-reference/show-functions/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/procedural-sql-reference/show-functions/)

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