[ LIST | SHOW ] DATABASES;
A database is listed only if the current role has USAGE privileges.
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 |
+------------+-------------+------------+-------------------------------+