# DROP TABLE

> 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 TABLE
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/drop-table
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-table.adoc
page-edit-url: https://github.com/redpanda-data/cloud-docs/edit/main/modules/reference/pages/sql/sql-statements/drop-table.adoc
description: The DROP TABLE statement removes a table that was mapped to a Redpanda topic through a 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/drop-table.md -->

The `DROP TABLE` statement removes a table that was mapped to a Redpanda topic through a catalog. This does not delete the underlying Redpanda topic.

## [](#syntax)Syntax

```sql
DROP TABLE [IF EXISTS] catalog_name=>table_name;
```

-   `catalog_name`: Name of the Redpanda catalog containing the table.

-   `table_name`: Name of the table to remove.

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


## [](#examples)Examples

```sql
DROP TABLE default_redpanda_catalog=>transactions;
```

```sql
DROP TABLE IF EXISTS default_redpanda_catalog=>old_events;
```