SHOW FUNCTIONS

Lists all available SQL functions (scalar, aggregate, and window functions).

Basic Syntax

SHOW FUNCTIONS;
SHOW FUNCTION;  -- Also accepted

Example

SHOW FUNCTIONS;

Output:

name       type
---------  ---------
UPPER      SCALAR
COUNT      AGGREGATE
ROW_NUMBER WINDOW
...