SHOW
The SHOW statement inspects the database — it lists tables, databases and schemas, shows the schema of a relation and displays the values of session variables.
SHOW
SHOW TABLE <name> returns the columns of a table and their types, the same as DESCRIBE TABLE <name>. Without the TABLE keyword, a name after SHOW is read as a setting, even if a table of that name exists: a server sets show_behavior to SETTING, so SHOW <name> shows the setting <name> (see Session variables).
SHOW TABLES
SHOW TABLES lists the tables in the current database and schema:
SHOW TABLES;name ---------- products
Use SHOW TABLES FROM <database> to list the tables of another attached database.
SHOW DATABASES
SHOW DATABASES lists every attached database. This includes SereneDB's internal catalogs — the transactional store (__sdb_store) and the default in-memory database (memory) — alongside your own databases:
SHOW DATABASES;SHOW SCHEMAS
SHOW SCHEMAS lists the schemas of every attached database, internal catalogs included:
SHOW SCHEMAS;Each row pairs a database with one of its schemas; the current column marks the default schema, set via the USE statement.
Session variables
SHOW <variable> displays the current value of a session variable:
SHOW search_path;search_path ----------------- "$user", public
SHOW ALL displays every variable with its value and description:
SHOW ALL;
DETACH IF EXISTS db81;