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

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

Last modified: May 15, 2025

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

(Optional) Run the following command to view the associated signature files.
Shell
```
curl undefined
```
Download the signature file from the SingleStore release server.
- Option 1: Click the Download Signature button next to the SingleStore file.
- Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.
- Option 3: Run the following command to download the signature file.
  Shell
```
curl -O undefined
```

After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

Shell

echo -n undefined |
    cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
      --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
      --bundle undefined \
      --new-bundle-format -

Verified OK