📄️ SHOW CREATE DATABASE
Shows the CREATE DATABASE statement that creates the named database.
📄️ 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 DROP TABLES
Lists the dropped tables in the current or a specified database.
📄️ SHOW COLUMNS
Shows information about the columns in a given table.
📄️ SHOW FUNCTIONS
Shows the list of supported functions currently, including builtin scalar/aggregate functions and user-defined functions.
📄️ SHOW INDEXES
Shows the created aggregating indexes. Equivalent to SELECT * FROM system.indexes.
📄️ 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 executed within the server.
📄️ SHOW SETTINGS
Shows all the system settings of the current session.
📄️ SHOW TABLE_FUNCTIONS
Shows the list of supported table functions currently.
📄️ SHOW TABLE STATUS
Shows the status of the tables in a database. The status information includes various physical sizes and timestamps about a table, see Examples for details.
📄️ SHOW TABLES
Lists the tables in the current or a specified database.
📄️ SHOW USERS
Shows the list of user accounts.