SHOW SCHEMAS

List the schemas in the ChaosSearch catalog.

Use SHOW SCHEMAS to list the schemas in the ChaosSearch catalog. There are two schemas:

chaos contains the ChaosSearch Refinery views as tables
information_schema contains the metadata including tables, columns, and schemas

SHOW SCHEMAS [ FROM catalog ] [ LIKE pattern ]

Examples

SHOW SCHEMAS from catalog like 'cha%';

Schema
chaos

Updated about 1 year ago