Sign inTry Free
  • Introduction
    • Deploy
      • Connect to Your Cluster
        • Create a Database
          • Integrate with SingleStoreDB
          • Load Data
            • Query Data
              • Manage Data
                • Developer Resources
                  • User and Cluster Administration
                    • Reference
                      • Configuration Reference
                        • SingleStoreDB Operator Reference
                          • MemSQL Ops CLI 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
                                    • 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
                                                              • 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 CREATE PIPELINE
                                                                                  • SHOW COLUMNS
                                                                                  • 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 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
                                                                                        • Security
                                                                                          • Release Notes
                                                                                            • Support
                                                                                              • Glossary
                                                                                              1. Self-Managed v7.3
                                                                                              2. /
                                                                                              3. ...
                                                                                              4. /
                                                                                              5. SHOW Commands

                                                                                              SHOW Commands

                                                                                              In this section

                                                                                              • SHOW CREATE PIPELINE
                                                                                              • SHOW COLUMNS
                                                                                              • 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 SCHEMAS
                                                                                              • SHOW SESSION STATUS
                                                                                              • SHOW STATUS EXTENDED
                                                                                              • SHOW TABLE STATUS
                                                                                              • SHOW TABLES
                                                                                              • SHOW VARIABLES
                                                                                              • SHOW WARNINGS
                                                                                              • System Status

                                                                                              Last modified: January 24, 2023

                                                                                              Was this article helpful?

                                                                                              Strict Mode Permissions
                                                                                              SHOW CREATE PIPELINE

                                                                                              Product

                                                                                              • Product Overview
                                                                                              • Solutions
                                                                                              • Pricing
                                                                                              • Support

                                                                                              Community

                                                                                              • Forums
                                                                                              • Developer Hub
                                                                                              • Events
                                                                                              • Training

                                                                                              Company

                                                                                              • Contact Us
                                                                                              • Blog
                                                                                              • Careers
                                                                                              • SingleStore Connect

                                                                                              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?