Skip to main content

SHOW FUNCTIONS

Returns the list of functions after applying an optional pattern.

Syntax
SHOW FUNCTIONS [ LIKE { <pattern> } ]

Parameters

[ 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 functions
CREATE FUNCTION hello()  RETURNS VARCHAR RETURN 'Hello World!';
CREATE FUNCTION teapot() RETURNS VARCHAR RETURN '418 I am a teapot';
List all user-defined functions in the current project
SHOW FUNCTIONS;
-- hello
-- teapot
List a user-defined function by name
SHOW FUNCTIONS LIKE 'hello';
-- hello
List all functions starting with 't'
SHOW FUNCTIONS LIKE 't%';
-- teapot