Peaka home page
Search...
⌘K
Ask AI
Support
Peaka Studio
Peaka Studio
Search...
Navigation
Reference
SHOW CATALOGS
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 CATALOGS
Synopsis
Copy
Ask AI
SHOW CATALOGS [ LIKE pattern ]
Description
List the available catalogs.
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 catalogs that begin with
t
:
Copy
Ask AI
SHOW CATALOGS
LIKE
't%'
SELECT
SHOW COLUMNS
Assistant
Responses are generated using AI and may contain mistakes.