Skip to main content
Outputs the CREATE FUNCTION ENVIRONMENT statement used to create the given Python UDF/UDTF environment(s).
SHOW FUNCTION ENVIRONMENT Syntax
The response to SHOW FUNCTION ENVIRONMENT is a single-column result set with the DDL statement as the value in the DDL column.

​
Parameters

<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:
SHOW FUNCTION ENVIRONMENT Example
To show all Python UDF environments:
SHOW FUNCTION ENVIRONMENT (All Environments) Example