SHOW FUNCTIONS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Lists any existing user-defined functions in the specified database, including user-defined scalar-valued functions (UDFs) and user-defined table-valued functions (TVFs).
Syntax
SHOW FUNCTIONS [{FROM | IN} database_name] [LIKE pattern]
Remarks
The SHOW FUNCTIONS
command can be used to list functions in the current database or in another database.
The Data Format column can be one of: JSON or ROWDAT_
The Link column shows the Connection Link.
Example
The following example lists each function in the current database.
SHOW FUNCTIONS;
+---------------------+-----------------------+---------+-------------+----------------+-----------+
| Functions_in_testDB | Function Type | Definer | Data Format | Runtime Type | Link |
+---------------------+-----------------------+---------+-------------+----------------+-----------+
| tvf_1 | Table Valued Function | root@% | | PSQL | |
| check_spacingExt | User Defined Function | root@% | JSON | Remote Service | HTTP_link |
+---------------------+-----------------------+---------+-------------+----------------+-----------+
1 row in set (0.00 sec)
Related Topics
Last modified: May 15, 2025