我的书签
添加书签
移除书签SHOW SCHEMAS
Lists the table schemas of the database.
Table of Contents
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 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.
WHERE
The optional WHERE clause defines the condition to be met for a row to be returned.
