Skip to main content

SHOW FUNCTIONS

Returns the list of user-defined functions (UDFs) after applying an optional pattern.

Syntax 
SHOW FUNCTIONS
    [ AS OF <timestamp> ]
  [ LIKE { <pattern> } ]

To run SHOW FUNCTIONS, users need the USAGE privilege on the catalog and SELECT privilege on the catalog or folder where the UDF exists.

Parameters​

AS OF <timestamp> String   Optional

[ LIKE { <pattern> } ] Optional

A LIKE pattern that is used to filter the results of the statement. The leading and trailing blanks are trimmed in the input pattern before processing. The pattern match is case-insensitive.

Examples​

Create test UDFs 
CREATE FUNCTION hello()  RETURNS VARCHAR RETURN 'Hello World!';
CREATE FUNCTION teapot() RETURNS VARCHAR RETURN '418 I am a teapot';
List all UDFs in the current project 
SHOW FUNCTIONS;
-- hello
-- teapot
List a UDF by name 
SHOW FUNCTIONS LIKE 'hello';
-- hello
List all UDFs starting with 't' 
SHOW FUNCTIONS LIKE 't%';
-- teapot