SHOW FUNCTIONS
Returns the list of functions after applying an optional pattern.
SyntaxSHOW 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 functionsCREATE FUNCTION hello() RETURNS VARCHAR RETURN 'Hello World!';
CREATE FUNCTION teapot() RETURNS VARCHAR RETURN '418 I am a teapot';
SHOW FUNCTIONS;
-- hello
-- teapot
SHOW FUNCTIONS LIKE 'hello';
-- hello
SHOW FUNCTIONS LIKE 't%';
-- teapot