> ## Documentation Index
> Fetch the complete documentation index at: https://docs.risingwave.com/llms.txt
> Use this file to discover all available pages before exploring further.

# SHOW FUNCTIONS

> Run `SHOW FUNCTIONS` to get a list of existing [user-defined functions](/sql/udfs/user-defined-functions). The returned information includes the name, argument types, return type, language, and server address of each function.

## Syntax

```bash theme={null}
SHOW FUNCTIONS [ FROM schema_name ] [ LIKE_expression ];
```

## Parameters

| Parameter or clause | Description                                                                                                                                                                                                                                                                                                                          |
| :------------------ | :----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| *schema\_name*      | The schema of the functions to be listed. If not specified, functions from all schemas in the current schema [search\_path](https://docs.risingwave.com/operate/view-configure-runtime-parameters#how-to-view-runtime-parameters:~:text=multi%20point%20lookup.-,search_path,-%E2%80%9D%24user%E2%80%9D%2C%20public) will be listed. |
| LIKE\_expression    | Filters the output based on names by applying pattern matching. See details in [LIKE pattern matching expressions](/sql/functions/string#like-pattern-matching-expressions).                                                                                                                                                         |

## Example

```sql theme={null}
       Name              | Arguments                 | Return Type                                                               | Language | Link                   
-------------------------+---------------------------+---------------------------------------------------------------------------+----------+-------------------------
 public.jsonb_concat     | jsonb[]                   | jsonb                                                                     | python   | http://localhost:8815
 public.array_access     | varchar[], integer        | varchar                                                                   | python   | http://localhost:8815
 public.hex_to_dec       | varchar                   | numeric                                                                   | python   | http://localhost:8815
 public.gcd              | integer, integer, integer | integer                                                                   | python   | http://localhost:8815
 public.gcd              | integer, integer          | integer                                                                   | python   | http://localhost:8815
 public.extract_tcp_info | bytea                     | struct<src_ip varchar,dst_ip varchar,src_port smallint,dst_port smallint> | python   | http://localhost:8815
 public.int_42           |                           | integer                                                                   | python   | http://localhost:8815
 public.series2          | integer                   | struct<x integer,y varchar>                                               | python   | http://localhost:8815
 public.series           | integer                   | integer                                                                   | python   | http://localhost:8815
 public.jsonb_access     | jsonb, integer            | jsonb                                                                     | python   | http://localhost:8815
(10 rows)

```

<Note>
  Starting from v2.7.0, the `Name` column in the output includes the schema name as a prefix (e.g., `public.function_name`). This helps distinguish functions with the same name in different schemas when querying across multiple schemas in the search path.
</Note>