SHOW SCHEMAS

Core command SH SC SHSC

Displays a list of schemas in the current database

Arguments

<schemaName> (optional) a search text, can be a schema name or a part of it

Examples

SHOW SCHEMAS;	returns all schemas in current database
SHOW SCHEMAS MYSC;	returns all schemas which name contains string MYSC, ignoring case

Notes

Lists the schemas available in the current database: SHOW SCHEMAS, flagging which one is the connection's current schema.

schemaName is optional and acts as a case-insensitive "contains" filter (a plain substring search, not a %-wildcard pattern): only schemas whose name includes it are listed. With no argument, every schema is listed.

Last modified in release 4.9.8.