Skip to main content

SHOW and SHOW DATABASE Statements

SHOW Statement​

The SHOW statement is an alias for DESCRIBE. It shows the schema of a table, view or query.

SHOW DATABASES Statement​

The SHOW DATABASES statement shows a list of all attached databases:

ATTACH 'my.goose' AS my_database;
SHOW DATABASES;
database_name
memory
my_database
DETACH my_database;
SHOW DATABASES;
database_name
memory