The SHOW DATABASES command lists all available data sources and projects. The WHERE clause filters all projects.
SHOW DATABASES
WHERE
Here is the syntax:
SHOW DATABASES WHERE type = 'project';
Alternatively, you can use the FULL keyword to get more information:
FULL
SHOW FULL DATABASES WHERE type = 'project';
