ContextQMD
Back to Trino

SHOW FUNCTIONS

docs/src/main/sphinx/sql/show-functions.md

4801.8 KB
Original Source

SHOW FUNCTIONS

Synopsis

text
SHOW FUNCTIONS [ FROM schema ] [ LIKE pattern ]

Description

List functions in schema or all functions in the current session path. This can include built-in functions, functions from a custom plugin, and .

For each function returned, the following information is displayed:

  • Function name
  • Return type
  • Argument types
  • Function type
  • Deterministic
  • Description

Use the optional FROM keyword to only list functions in a specific catalog and schema. The location in schema must be specified as cataglog_name.schema_name.

{ref}Specify a pattern <like-operator> in the optional LIKE clause to filter the results to the desired subset.

Examples

List all UDFs and plugin functions in the default schema of the example catalog:

sql
SHOW FUNCTIONS FROM example.default;

List all functions with a name beginning with array:

sql
SHOW FUNCTIONS LIKE 'array%';

List all functions with a name beginning with cf:

sql
SHOW FUNCTIONS LIKE 'cf%';

Example output:

text
     Function      | Return Type | Argument Types | Function Type | Deterministic |               Description
 ------------------+-------------+----------------+---------------+---------------+-----------------------------------------
 cf_getgroups      | varchar     |                | scalar        | true          | Returns the current session's groups
 cf_getprincipal   | varchar     |                | scalar        | true          | Returns the current session's principal
 cf_getuser        | varchar     |                | scalar        | true          | Returns the current session's user

See also