tencent cloud

SHOW FUNCTION

Last updated: 2024-08-07 17:24:44

SHOW FUNCTION

Last updated: 2024-08-07 17:24:44

Description
Supported engines: Presto and SparkSQL
Purpose: Display function creation statements.
Statement
SHOW FUNCTIONS [ [ LIKE ] { function_name | regex_pattern } 
Parameter
function_name: Function name
regex_pattern: Regular expression for obtaining matching functions
Example
SHOW FUNCTIONS
﻿
SHOW FUNCTIONS trim;
﻿
SHOW FUNCTIONS LIKE 't*'
SHOW FUNCTIONS LIKE 'yea*|windo*'
SHOW FUNCTIONS LIKE 't[a-z][a-z][a-z]'
﻿
﻿
﻿

Was this page helpful?

You can also Contact Sales or Submit a Ticket for help.

Yes

No

Feedback