Description

The SHOW DATABASES command lists all available data sources and projects. The WHERE clause filters all projects.

Syntax

Here is the syntax:

SHOW DATABASES
WHERE type = 'project';

Alternatively, you can use the FULL keyword to get more information:

SHOW FULL DATABASES
WHERE type = 'project';