Peaka home page
Search...
⌘K
Ask AI
Support
Peaka Studio
Peaka Studio
Search...
Navigation
Reference
SHOW SCHEMAS
Documentation
API Reference
Embedded Peaka
SQL Reference
Integrations
BI Tools
DB Drivers
JEXL
Flows
How to Guides
Blogs
Documentation
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
Regexp
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
On this page
Synopsis
Description
Reference
SHOW SCHEMAS
Synopsis
Copy
Ask AI
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:
Copy
Ask AI
SHOW SCHEMAS
FROM
tpch
LIKE
'__3%'
SHOW COLUMNS
USE
Assistant
Responses are generated using AI and may contain mistakes.