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%'
success-mail-img

You've joined our email list. Our newsletter will be delivered to your inbox every other week, with news from Peaka and the no-code world, as well as updates on the latest trends and developments in the data integration space!

success-mail-img

Thank you for your interest. We'll contact you soon.