On this page

SHOW CATALOGS

Core command SH CA SHCA

Lists the catalogs of the current database.

Syntax

SHOW CATALOGS [<text>]

Arguments

ArgumentRequiredValuesDefault
<text>NoText the catalog name contains, ignoring caseEvery catalog

Examples

Every catalog of the current database
SHOW CATALOGS;
The catalogs whose name contains MYCAT, ignoring case
SHOW CATALOGS MYCAT;

Details

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

Last modified in release 5.5.0.

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