LIST DATABASES

Syntax

{ LIST | SHOW } DATABASES;

Description

This command provides a list of Databases within the Organization.

A Database will only be listed if current role has USAGE privileges.

Examples

demodb.public/demostore# LIST DATABASES;
   Name   | Default |  Owner   |      Created at      |      Updated at       
----------+---------+----------+----------------------+-----------------------
  testdb  | ✓       | sysadmin | 2023-01-11T19:59:26Z | 2023-01-11T19:59:26Z  
  otherdb |         | sysadmin | 2023-02-09T23:05:01Z | 2023-02-09T23:05:01Z