# DROP REDPANDA CATALOG

> 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: DROP REDPANDA CATALOG
latest-operator-version: v26.2.1
latest-console-tag: v3.9.0
latest-connect-version: 4.104.0
latest-redpanda-tag: v26.2.1
docname: sql/sql-statements/drop-redpanda-catalog
page-component-name: cloud-data-platform
page-version: master
page-component-version: master
page-component-title: Cloud
page-relative-src-path: sql/sql-statements/drop-redpanda-catalog.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/drop-redpanda-catalog.adoc
description: The DROP REDPANDA CATALOG statement removes a Redpanda catalog connection.
page-topic-type: reference
page-git-created-date: "2026-05-26"
page-git-modified-date: "2026-08-03"
---

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

The `DROP REDPANDA CATALOG` statement removes a Redpanda catalog connection. You must drop all tables within a catalog before dropping the catalog itself.

> 📝 **NOTE**
>
> In Redpanda Cloud, the storage connection and Iceberg catalog used to query Iceberg-enabled topics are configured and managed automatically when you enable Redpanda SQL on a cluster that has an [Iceberg REST catalog](https://docs.redpanda.com/cloud-data-platform/manage/iceberg/rest-catalog/) configured. You don’t run these statements yourself for that workflow. This page documents the statement’s syntax and options so you can understand what Redpanda Cloud configures. See [Query Iceberg-enabled topics](https://docs.redpanda.com/cloud-data-platform/sql/query-data/query-iceberg-topics/).

## [](#syntax)Syntax

```sql
DROP REDPANDA CATALOG [IF EXISTS] catalog_name;
```

-   `catalog_name`: Name of the catalog to remove.

-   `IF EXISTS`: Optional. Prevents an error if the catalog does not exist.


## [](#examples)Examples

First, drop all tables in the catalog:

```sql
DROP TABLE production_redpanda=>user_events;
DROP TABLE production_redpanda=>transactions;
```

Then drop the catalog:

```sql
DROP REDPANDA CATALOG production_redpanda;
```