SHOW SCHEMAS statement

Synopsis

SHOW SCHEMAS [ FROM catalog ] [ LIKE pattern ]

Syntax diagram

Read syntax diagramSkip visual syntax diagram SHOW SCHEMASFROMcataglogLIKEpattern

For information on reading syntax diagrams, see How to read syntax diagrams

Description

List the schemas in catalog or in the current catalog. The LIKE clause can be used to restrict the list of schema names.