> ## 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 ENVIRONMENT

Outputs the [CREATE FUNCTION ENVIRONMENT](https://docs.kinetica.com/content/sql/udf/create-function-environment.md#sql-create-function-environment) statement used to
create the given
[Python UDF/UDTF environment(s)](https://docs.kinetica.com/content/sql/udf/create-function-environment.md#sql-create-function-environment).

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

> [!NOTE]
>
> The response to `SHOW FUNCTION ENVIRONMENT` is a single-column
> result set with the DDL statement as the value in the `DDL` column.

## Parameters

> [accordion] \<environment name>
>
> Name of the UDF environment whose `CREATE` statement will be output. Use `*` instead to
> output the `CREATE` statements of all UDF environments.

## Examples

To show the Python UDF environment `udfe_st`:

```sql SHOW FUNCTION ENVIRONMENT Example theme={null}
SHOW FUNCTION ENVIRONMENT udfe_st
```

To show all Python UDF environments:

```sql SHOW FUNCTION ENVIRONMENT (All Environments) Example theme={null}
SHOW FUNCTION ENVIRONMENT *
```


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