Dremio Cloud
Dremio Software
 
On this page

    SHOW FUNCTIONS

    Show all or specific user-defined functions (UDF) by using parameters.

    Syntax 
    SHOW FUNCTIONS [ LIKE ]

    Parameters

    [ LIKE ]

    Optional

    The pattern match is case-insensitive, but must be used with the LIKE operator.

    Examples

    Show all existing functions 
    SHOW FUNCTIONS
    Show an existing function with the exact name protect_ssn 
    SHOW FUNCTIONS LIKE 'protect_ssn'
    Show all existing functions with names that start with protect_ 
    SHOW FUNCTIONS LIKE 'protect_%'