SHOW SCHEMAS

Lists the table schemas of the database.

Synopsis

SHOW SCHEMAS [LIKE 'pattern' | WHERE expression]

Description

SHOW SCHEMAS can be used to retrieve defined schema names of the database in alphabetical order.

The same list can be fetched by querying the schema names from the information_schema.schemata table.

Clauses

LIKE

The optional LIKE clause indicates which schema names to match. It takes a string pattern as a filter and has an equivalent behavior to LIKE (ILIKE).

WHERE

The optional WHERE clause defines the condition to be met for a row to be returned.