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.

Syntax

SQL

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 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

The following example lists each function in the current database.

SQL

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