SHOW Statement#
The SHOW statement lists catalog tables and supports filtering by namespace and SQL LIKE patterns.
Syntax#
1 | |
| Parameter | Description |
|---|---|
<catalog> | Catalog name to query. If omitted, the current catalog must be set. |
<namespace> | Optional namespace inside the catalog. |
<pattern> | Pattern to match table names. Pattern syntax is catalog-dependent. Native/memory catalogs and Postgres support SQL LIKE syntax (%, _, \). Other catalogs like Iceberg, S3 Tables, and Glue use different pattern matching (e.g., prefix matching, catalog-specific expressions). |
Note
Pattern support is catalog-dependent. Native/memory catalogs and Postgres support SQL LIKE syntax (%, _, \). Other catalogs like Iceberg and S3 Tables use prefix matching, while Glue uses AWS Glue expression syntax. Please see issue #4007 for better pattern support.
Examples#
Show tables in the current catalog.
1 | |
Show tables in the current catalog matching the pattern.
1 | |
Show tables in catalog my_catalog and schema public.
1 | |
Show tables in catalog my_catalog under public matching the pattern.
1 | |