Documentation / Commands / SHOW CATALOGS

SHOW CATALOGS

Core command SH CA SHCA

Displays a list of catalogs in the current database

Arguments

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

Examples

SHOW CATALOGS;	returns all catalogs in current database
SHOW CATALOGS MYCAT;	returns all catalogs which name contains string MYCAT, ignoring case

Notes

Lists the catalogs available in the current database: SHOW CATALOGS.

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

Last modified in release 4.9.8.