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.duckdb' AS my_database;
SHOW DATABASES;

DETACH my_database;
SHOW DATABASES;