On this page
SHOW CATALOGS
Core command
SH CA
SHCA
Lists the catalogs of the current database.
Syntax
SHOW CATALOGS [<text>]
Arguments
| Argument | Required | Values | Default |
|---|---|---|---|
<text> | No | Text the catalog name contains, ignoring case | Every catalog |
Examples
SHOW CATALOGS;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.
Related
Last modified in release 5.5.0.
Found something wrong or unclear on this page? Tell us, with the page address.