On this page 
Warning:
As of November 10, 2018, CockroachDB v1.0 is no longer supported. For more details, refer to the Release Support Policy.
The SHOW DATABASES statement lists all database in the CockroachDB cluster.
Synopsis
Required Privileges
No privileges are required to list the databases in the CockroachDB cluster.
Example
> SHOW DATABASES;
+--------------------+
| Database |
+--------------------+
| bank |
| crdb_internal |
| information_schema |
| pg_catalog |
| system |
+--------------------+
(5 rows)
See Also
Was this helpful?
