On this page

SHOW CATALOGS

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

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%';
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback