Lists the table schemas of the database.
Table of contents
SHOW SCHEMAS [LIKE 'pattern' | WHERE expression]
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 the schema names from the information_schema.schemata
table.
The optional LIKE
clause indicates which schema names to match. It takes a string pattern as a filter and has an equivalent behavior to sql_dql_like
.
The optional WHERE clause defines the condition to be met for a row to be returned.