LIST DATABASES

Syntax

[ LIST | SHOW ] DATABASES;

Description

This command provides a list of databases within the organization.

A database is listed only if the current role has USAGE privileges.

Examples

demodb.public/demostore# LIST DATABASES;
+------------+-------------+------------+-------------------------------+
|  Name      |  Is Default |  Owner     |  Created At                   |
+============+=============+============+===============================+
| demodb     | true        | sysadmin   | 2024-07-02 16:23:26 +0000 UTC |
+------------+-------------+------------+-------------------------------+
| otherdb    | false       | sysadmin   | 2024-06-28 21:21:18 +0000 UTC |
+------------+-------------+------------+-------------------------------+