Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> User-Defined Functions> Displaying All Functions
View PDF

Displaying All Functions

Function

View all functions in the current project.

Syntax

1
 
SHOW [USER|SYSTEM|ALL] FUNCTIONS ([LIKE] regex | [db_name.] function_name);

Keywords

LIKE: This qualifier is used only for compatibility and has no actual effect.

Precautions

The function that matches the given regular expression or function name are displayed. If no regular expression or name is provided, all functions are displayed. If USER or SYSTEM is specified, user-defined Spark SQL functions and system-defined Spark SQL functions are displayed, respectively.

Example

This statement is used to view all functions.

1
 
SHOW FUNCTIONS;
Parent topic: User-Defined Functions