SHOW FUNCTIONS
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 FUNCTIONScommand can be used to list functions in the current database or in another database.The function list returns the name for each function and who is the function definer. To show user-defined aggregate functions (UDAFs), see SHOW AGGREGATES. Use SHOW PROCEDURES to list stored procedures. -
The Data Format column can be one of: JSON or ROWDAT_
1. -
The Link column shows the Connection Link.
Example - List Functions
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: March 11, 2026