# SHOW TABLES

> For the complete documentation index, see [llms.txt](https://docs.redpanda.com/llms.txt). Component-specific: [cloud-data-platform-full.txt](https://docs.redpanda.com/cloud-data-platform-full.txt)

---
title: SHOW TABLES
latest-operator-version: v26.1.4
latest-console-tag: v3.7.3
latest-connect-version: 4.93.0
latest-redpanda-tag: v26.1.9
docname: sql/sql-statements/show-tables
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-statements/show-tables.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/show-tables.adoc
description: The SHOW TABLES statement retrieves information about existing tables, including tables mapped from Redpanda topics and Iceberg tables registered in the local catalog.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-05-26"
---

<!-- Source: https://docs.redpanda.com/cloud-data-platform/reference/sql/sql-statements/show-tables.md -->

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.

> 📝 **NOTE**
>
> `SHOW TABLES` variants only display tables in schemas where the user has the `USAGE` grant.

## [](#syntax)Syntax

```sql
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)Examples

### [](#list-tables-from-a-redpanda-catalog)List tables from a Redpanda catalog

To list tables mapped through a specific Redpanda catalog:

```sql
SHOW REDPANDA TABLES default_redpanda_catalog;
```

To list all Redpanda-catalog tables across all connections:

```sql
SHOW REDPANDA TABLES;
```

### [](#list-iceberg-tables)List Iceberg tables

To list all Iceberg tables registered in the local catalog:

```sql
SHOW ICEBERG TABLES;
```

To list Iceberg tables in a specific catalog:

```sql
SHOW ICEBERG TABLES lakehouse_catalog;
```

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

```sql
SHOW ICEBERG TABLES analytics.lakehouse_catalog;
```