Show Commands

This page provides reference information for the show-related commands in Databend.

Database and Table Information:

• SHOW CREATE DATABASE
• SHOW CREATE TABLE
• SHOW DATABASES
• SHOW DROP TABLES
• SHOW COLUMNS
• SHOW TABLE STATUS
• SHOW TABLES

Function and Index Information:

• SHOW FUNCTIONS
• SHOW INDEXES
• SHOW TABLE_FUNCTIONS

Performance, System, and User Information:

• SHOW METRICS
• SHOW PROCESSLIST
• SHOW SETTINGS
• SHOW USERS