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.
SHOW FUNCTION Syntax
Parameters
<function name>
<function name>
Name of the UDF whose configuration will be output. Use
* instead to output the DDL of
all UDFs.The response to
SHOW FUNCTION is a single-column result set
with the DDL statement as the value in the DDL column.Examples
To show theUDF_SOS_PY_PROC UDF:
SHOW FUNCTION Example