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

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

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

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

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

## Parameters

<AccordionGroup>
  <Accordion title="<environment name>" id="<environment-name>" defaultOpen>
    Name of the UDF environment whose `CREATE` statement will be output. Use `*` instead to
    output the `CREATE` statements of all UDF environments.
  </Accordion>
</AccordionGroup>

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