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%';
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.