Lists tables in the catalog, optionally filtered by schema or name pattern.
SHOW TABLES [IN <zone.schema>] [LIKE '<pattern>']## Overview Returns a result set listing tables registered in the control plane catalog. Tables are the third level of the DeltaForge three-level namespace (zone.schema.table). This command supports filtering by parent schema and by name pattern. ## Behavior - Without any filters, returns all tables across all zones and schemas. - When IN is specified, the qualifier is parsed as a dotted name. If two-part (zone.schema), both zone and schema filters are applied. If single-part, it is treated as a schema filter across all zones. - The SCHEMA keyword after IN is optional and does not change behavior. - When LIKE is specified, the pattern is applied to table names using SQL wildcard matching (% and _), case-insensitively. - Both IN and LIKE can be combined. The schema 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 table metadata such as table name, zone, schema, format, location, and audit timestamps. ## Compatibility SHOW TABLES is a DeltaForge extension that follows common SQL conventions for listing tables. It queries the control plane catalog rather than an information_schema view.
-- List all tables across all zones and schemas
SHOW TABLES;-- List tables in a specific schema
SHOW TABLES IN bronze.raw;-- List tables using the optional SCHEMA keyword
SHOW TABLES IN SCHEMA bronze.raw;-- Find tables whose names contain 'events'
SHOW TABLES LIKE '%events%';-- Combine schema filter and name pattern
SHOW TABLES IN gold.analytics LIKE '%daily%';