On this page

SHOW SCHEMAS

Core command SH SC SHSC

Lists the schemas of the current database.

Syntax

SHOW SCHEMAS [<text>]

Arguments

Argument	Required	Values	Default
`<text>`	No	Text the schema name contains, ignoring case	Every schema

Examples

Every schema of the current database

SHOW SCHEMAS;

The schemas whose name contains MYSC, ignoring case

SHOW SCHEMAS MYSC;

Details

The list flags the connection's current schema.

The filter is a plain, case-insensitive "contains" search, not a % pattern: only the schemas whose name includes the text are listed. Without it, every schema is listed.

SET SCHEMA
SHOW CATALOGS
SHOW TABLES

Used in these how-tos

How do I explore an unfamiliar database in fifteen minutes?

Last modified in release 5.5.0.

Found something wrong or unclear on this page? Tell us, with the page address.