SHOW Commands
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
In this section
- SHOW CDC EXTRACTOR POOL
- SHOW COLUMNS
- SHOW CREATE LINK
- SHOW CREATE PIPELINE
- SHOW CREATE PROJECTION
- SHOW CREATE TABLE
- SHOW CREATE VIEW
- SHOW DATABASES
- SHOW DATABASE STATUS
- SHOW ERRORS
- SHOW FULLTEXT SERVICE METRICS
- SHOW FULLTEXT SERVICE STATUS
- SHOW GC STATUS
- SHOW GLOBAL STATUS
- SHOW INDEX, SHOW INDEXES, SHOW KEYS
- SHOW INDEXES
- SHOW KEYS
- SHOW LEAF STATUS
- SHOW LOAD ERRORS
- SHOW LOAD WARNINGS
- SHOW PARTITIONS
- SHOW PIPELINES
- SHOW PLAN
- SHOW PLANCACHE
- SHOW PRIVILEGES
- SHOW PROCESSLIST
- SHOW PROJECTIONS
- SHOW REPRODUCTION
- SHOW SCHEMAS
- SHOW SESSION STATUS
- SHOW STATUS EXTENDED
- SHOW TABLE STATUS
- SHOW TABLES
- SHOW VARIABLES
- SHOW WARNINGS
- System Status
Last modified: June 3, 2025