Upsolve AI home pagelight logodark logo
  • Support
  • Request Access
  • Request Access
Reference
SHOW SCHEMAS
Documentation
Chart Configuration
Integrations
API Reference
Demo
Dashboard Example
SQL Reference
  • Impact Studies
  • Security Trust Center
  • Community
  • Blog
  • SQL
    • Introduction
    Reference
    • DESCRIBE
    • EXECUTE
    • PREPARE
    • SELECT
    • SHOW CATALOGS
    • SHOW COLUMNS
    • SHOW SCHEMAS
    • USE
    • VALUES
    Data Types
    • Data types
    Functions
    • Aggregate functions
    • Array functions and operators
    • Binary functions and operators
    • Bitwise functions
    • Comparison functions and operators
    • Conditional Expressions
    • Conversion
    • Date and time functions and operators
    • Decimal functions and operators
    • HyperLogLog Functions
    • JSON functions and operators
    • Lambda expressions
    • Map
    • Machine learning functions
    • Quantile digest functions
    • Regular expression functions
    • Set Digest functions
    • String functions and operators
    • Table functions
    • Teradata functions
    • URL functions
    • UUID Functions
    • Window functions
    Routines
    • Introduction to SQL routines
    • Example SQL routines
    • BEGIN
    • CASE
    • DECLARE
    • FUNCTION
    • IF
    • ITERATE
    • LEAVE
    • LOOP
    • REPEAT
    • RETURN
    • SET
    • WHILE
    Reference

    SHOW SCHEMAS

    ​
    Synopsis

    SHOW SCHEMAS [ FROM catalog ] [ LIKE pattern ]
    

    ​
    Description

    List the schemas in catalog or in the current catalog.

    Specify a pattern in the optional LIKE clause to filter the results to the desired subset. For example, the following query allows you to find schemas that have 3 as the third character:

    SHOW SCHEMAS FROM tpch LIKE '__3%'
    

    Was this page helpful?

    Suggest editsRaise issue
    SHOW COLUMNSUSE
    websitelinkedinhacker-news
    Powered by Mintlify
    On this page
    • Synopsis
    • Description