Categories:

DDL for User-Defined Functions, External Functions, and Stored Procedures

SHOW EXTERNAL FUNCTIONS

Lists all the external functions created for your account.

For more information, see External Functions.

See also:

SHOW FUNCTIONS , SHOW USER FUNCTIONS

Syntax

SHOW EXTERNAL FUNCTIONS [ LIKE '<pattern>' ]

Parameters

LIKE 'pattern'

Filters the command output by object name. The pattern supports the SQL wildcard characters (% and _).

  • An underscore (_) matches any single character.

  • A percent sign (%) matches any sequence of zero or more characters.

The filter uses case-insensitive pattern matching. For example, the following patterns return the same results:

  • ... LIKE '%testing%' ...

  • ... LIKE '%TESTING%' ...

Usage Notes

  • The command does not require a running warehouse to execute.

  • The command returns a maximum of 10K records for the specified object type, as dictated by the access privileges for the role used to execute the command; any records above the 10K limit are not returned, even with a filter applied.

    To view results for which more than 10K records exist, query the corresponding view (if one exists) in the Information Schema.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

  • The commands SHOW FUNCTIONS and SHOW USER FUNCTIONS also display information about external functions.

Examples

Show all external functions:

SHOW EXTERNAL FUNCTIONS;

Show only external functions matching the specified regular expression:

SHOW EXTERNAL FUNCTIONS LIKE 'SQUARE%';