Cloud

SHOW TABLES

The SHOW TABLES statement retrieves information about existing tables in a catalog. Use one of the typed variants (SHOW REDPANDA TABLES, SHOW ICEBERG TABLES) or qualify with a catalog name (SHOW TABLES FROM catalog_name). The unqualified SHOW TABLES form is not supported and returns an error.

SHOW TABLES variants only display tables in schemas where the user has the USAGE grant.

Syntax

SHOW TABLES FROM catalog_name;

SHOW REDPANDA TABLES;
SHOW REDPANDA TABLES catalog_name;
SHOW REDPANDA TABLES schema.catalog_name;

SHOW KAFKA TABLES;
SHOW KAFKA TABLES catalog_name;
SHOW KAFKA TABLES schema.catalog_name;

SHOW ICEBERG TABLES;
SHOW ICEBERG TABLES catalog_name;
SHOW ICEBERG TABLES schema.catalog_name;

  • catalog_name: Required after SHOW TABLES FROM; optional after SHOW REDPANDA TABLES and SHOW ICEBERG TABLES. Filter by a specific Redpanda or Iceberg catalog.

  • schema.catalog_name: Optional. Filter by both schema and catalog. Useful when catalogs in different schemas share a name.

SHOW KAFKA TABLES is a synonym for SHOW REDPANDA TABLES.

Examples

List tables from a Redpanda catalog

To list tables mapped through a specific Redpanda catalog:

SHOW REDPANDA TABLES default_redpanda_catalog;

To list all Redpanda-catalog tables across all connections:

SHOW REDPANDA TABLES;

List Iceberg tables

To list all Iceberg tables registered in the local catalog:

SHOW ICEBERG TABLES;

To list Iceberg tables in a specific catalog:

SHOW ICEBERG TABLES lakehouse_catalog;

To list Iceberg tables in a specific schema and catalog (here, schema analytics, catalog lakehouse_catalog):

SHOW ICEBERG TABLES analytics.lakehouse_catalog;