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

# SHOW FUNCTION

<a id="sql-show-function" />

Outputs the configuration of one or more existing
[UDFs/UDTFs](/content/sql/udf#sql-udf). Users with `SYSTEM ADMIN` or `ADMIN`
permission on the UDF (or all UDFs) will see the entire UDF configuration, while
users with `EXECUTE` permissions will only see the name of the UDF & its
execution mode.

```sql title="SHOW FUNCTION Syntax" theme={null}
SHOW FUNCTION < <function name> | * >
```

## Parameters

<AccordionGroup>
  <Accordion title="<function name>" id="<function-name>" defaultOpen>
    Name of the UDF whose configuration will be output.  Use `*` instead to output the DDL of
    all UDFs.
  </Accordion>
</AccordionGroup>

<Info>
  The response to `SHOW FUNCTION` is a single-column result set
  with the DDL statement as the value in the `DDL` column.
</Info>

## Examples

To show the `UDF_SOS_PY_PROC` UDF:

```sql SHOW FUNCTION Example theme={null}
SHOW FUNCTION UDF_SOS_PY_PROC
```


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.