SingleStore LogoSingleStore Logo
or
Sign inTry Free
  • Introduction

    • Deploy

      • Connect to SingleStore

        • Create a Database

          • Load Data

            • Query Data

              • Manage Data

                • Developer Resources

                  • User and Cluster Administration

                    • Reference

                      • Configuration Reference

                        • SingleStore Operator Reference

                          • SingleStore Tools Reference

                            • SQL Reference

                              • SQL Command Syntax

                              • SQL Commands List

                              • SQL Functions List

                              • Comparison Operators and Functions

                                • Database Object Case-Sensitivity

                                • Data Types

                                  • Character Encoding

                                    • Operations that Take Either a Database or a Cluster Level Lock

                                      • User-Defined Variables

                                        • Restricted Keywords

                                          • Aggregate Functions

                                            • Cluster Management Commands

                                              • Code Generation Functions

                                                • Conditional Functions

                                                  • Data Definition Language DDL

                                                    • Data Manipulation Language DML

                                                      • Date and Time Functions

                                                        • Distinct Count Estimation Functions

                                                          • Full-Text Search Functions

                                                            • Geospatial Functions

                                                              • Identifier Generation Functions

                                                                • Information Functions

                                                                  • JSON Functions

                                                                    • Numeric Functions

                                                                      • Operational Commands

                                                                        • Pipelines Commands

                                                                          • Procedural SQL Reference

                                                                            • Regular Expression Functions

                                                                              • Resource Pool Commands

                                                                                • Security Management Commands

                                                                                  • SHOW Commands

                                                                                    • SHOW CHARACTER SET

                                                                                    • SHOW COLLATION

                                                                                    • SHOW COLUMNS

                                                                                    • SHOW CREATE PIPELINE

                                                                                    • SHOW CREATE TABLE

                                                                                    • SHOW CREATE VIEW

                                                                                    • SHOW DATABASES

                                                                                    • SHOW DATABASE STATUS

                                                                                    • SHOW ERRORS

                                                                                    • 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 PROFILE

                                                                                    • SHOW REPRODUCTION

                                                                                    • SHOW SCHEMAS

                                                                                    • SHOW SESSION STATUS

                                                                                    • SHOW STATUS EXTENDED

                                                                                    • SHOW TABLE STATUS

                                                                                    • SHOW TABLES

                                                                                    • SHOW VARIABLES

                                                                                    • SHOW WARNINGS

                                                                                    • System Status

                                                                                  • String Functions

                                                                                    • Time Series Functions

                                                                                      • Vector Functions

                                                                                        • Window Functions

                                                                                        • Troubleshooting Reference

                                                                                          • System Databases

                                                                                          • Information Schema Reference

                                                                                            • Data API

                                                                                            • Security

                                                                                              • Release Notes

                                                                                                • Support

                                                                                                  • Glossary

                                                                                                  1. Self-Managed v7.8/
                                                                                                  2. SQL Reference.../
                                                                                                  3. SHOW Commands
                                                                                                  AI agents/LLMs: Fetch /llms.txt first to access the documentation index. Remove the trailing slash and append .md to any URL to access lighter, easier-to-parse Markdown pages instead of HTML (this page is accessible at https://docs.singlestore.com/db/v7.8/reference/sql-reference/show-commands.md).

                                                                                                  SHOW Commands

                                                                                                  In this section

                                                                                                  • SHOW CHARACTER SET
                                                                                                  • SHOW COLLATION
                                                                                                  • SHOW COLUMNS
                                                                                                  • SHOW CREATE PIPELINE
                                                                                                  • SHOW CREATE TABLE
                                                                                                  • SHOW CREATE VIEW
                                                                                                  • SHOW DATABASES
                                                                                                  • SHOW DATABASE STATUS
                                                                                                  • SHOW ERRORS
                                                                                                  • 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 PROFILE
                                                                                                  • SHOW REPRODUCTION
                                                                                                  • SHOW SCHEMAS
                                                                                                  • SHOW SESSION STATUS
                                                                                                  • SHOW STATUS EXTENDED
                                                                                                  • SHOW TABLE STATUS
                                                                                                  • SHOW TABLES
                                                                                                  • SHOW VARIABLES
                                                                                                  • SHOW WARNINGS
                                                                                                  • System Status

                                                                                                  Last modified: June 23, 2026

                                                                                                  Was this article helpful?

                                                                                                  Strict Mode Permissions
                                                                                                  Product
                                                                                                  • Product Overview
                                                                                                  • Request a Demo
                                                                                                  • Pricing
                                                                                                  • Support
                                                                                                  • Status
                                                                                                  Community
                                                                                                  • Forums
                                                                                                  • Spaces
                                                                                                  • Events
                                                                                                  • Training
                                                                                                  Company
                                                                                                  • Contact Us
                                                                                                  • Blog
                                                                                                  • Careers
                                                                                                  • Partners

                                                                                                  This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

                                                                                                  • © SingleStore
                                                                                                  • |

                                                                                                  • Privacy Policy
                                                                                                  • |

                                                                                                  • Terms of Service
                                                                                                  • |

                                                                                                  • Legal Terms and Conditions

                                                                                                  Was this article helpful?