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