📄️ SHOW CREATE DATABASE
Shows the CREATE DATABASE statement that creates the named database.
SHOW Commands
📄️ SHOW CREATE TABLE
Shows the CREATE TABLE statement that creates the named table.
📄️ SHOW DATABASES
Shows the list of databases that exist on the instance.
📄️ SHOW FUNCTIONS
Shows the list of supported functions currently, including builtin scalar/aggregate functions and user defined functions.
📄️ SHOW METRICS
Shows the list of system metrics.
📄️ SHOW PROCESSLIST
The Databend process list indicates the operations currently being performed by the set of threads executing within the server.
📄️ SHOW SETTINGS
Shows the databend's SETTINGS.
📄️ SHOW TABLE STATUS
Shows the list of table status in the currently selected database.
📄️ SHOW TABLES
Shows the list of tables in the currently selected database.
📄️ SHOW USERS
Shows the list of user accounts.