Lists schemas in the catalog, optionally filtered by zone or name pattern.
SHOW SCHEMAS [IN <zone>] [LIKE '<pattern>']## Overview Returns a result set listing schemas registered in the control plane catalog. Schemas are the second level of the DeltaForge three-level namespace (zone.schema.table). This command supports filtering by parent zone and by name pattern. ## Behavior - Without any filters, returns all schemas across all zones. - When IN is specified, only schemas belonging to the named zone are returned. The ZONE keyword after IN is optional and does not change behavior. - When LIKE is specified, the pattern is applied to schema names using SQL wildcard matching (% and _), case-insensitively. - Both IN and LIKE can be combined. The zone filter is applied first, then the LIKE pattern filters the remaining results. - The command is routed through the control plane catalog API. A valid catalog router connection is required. - The result set includes schema metadata such as schema name, zone name, comment, and audit timestamps. ## Compatibility SHOW SCHEMAS is a DeltaForge extension that follows common SQL conventions for listing namespace objects. It queries the control plane catalog rather than an information_schema view.
-- List all schemas across all zones
SHOW SCHEMAS;-- List schemas in the bronze zone
SHOW SCHEMAS IN bronze;-- List schemas in the bronze zone using the optional ZONE keyword
SHOW SCHEMAS IN ZONE bronze;-- Find schemas whose names contain 'raw'
SHOW SCHEMAS LIKE '%raw%';-- Combine zone filter and name pattern
SHOW SCHEMAS IN silver LIKE '%curated%';