Updated on 2022-11-18 GMT+08:00

SHOW CATALOGS

Syntax

SHOW CATALOGS [ LIKE pattern [ESCAPE escapeChar] ]

Description

This expression is used to list available catalogs. The optional parameter like is used for keyword-based matching.

Example

  • List all catalogs:
    SHOW CATALOGS;
  • List all catalogs whose name prefix is sys:
    SHOW CATALOGS LIKE 'sys%';