[role="xpack"]
[testenv="basic"]
[[sql-syntax-show-functions]]
=== SHOW FUNCTIONS

.Synopsis
[source, sql]
----
SHOW FUNCTIONS [ LIKE? pattern<1>? ]?
----

<1> SQL match pattern

.Description

List all the SQL functions and their type. The `LIKE` clause can be used to restrict the list of names to the given pattern.
