---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/drop-table.md
cuppy_section: docs
cuppy_doc: AM84-BDMS
cuppy_doc_uuid: f42283b9-8f94-4b11-a70d-476dcf72ca6a
cuppy_permalink: https://cuppy.io/salesforce/d/AM84-BDMS
cuppy_version: 1
cuppy_updated: 2026-10-23T16:16:52.575Z
cuppy_canonical: https://cuppy.io/salesforce/docs/reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/drop-table
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 84521e22c4c4178c57422b4cec827af52d3616e77096cbafdc863115a1acbd72
# cuppy_body_sha256 is over the document body ALONE, excluding both generated blocks.
---

> Mirror of <https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/drop-table.html> (Salesforce, Data 360 Query Guide), read 2026-10-23. Salesforce's own page is the authority; this copy exists because that site refuses non-browser readers.

## DROP TABLE

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Remove a table.

`DROP TABLE` removes one or more tables from the database. To empty a table of rows without destroying the table, use [DELETE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/delete.html) or [TRUNCATE](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/truncate.html).

`IF EXISTS`
Do not throw an error if the table does not exist.

`<name>`
The name (optionally schema-qualified) of the table to drop.

`CASCADE`
Automatically drop objects that depend on the table (such as views), and in turn all objects that depend on those objects.

`RESTRICT`
Refuse to drop the table if any objects depend on it. This is the default.

To destroy two tables, `films` and `distributors`:

This command conforms to the SQL standard, except that the standard only allows one table to be dropped per command, and apart from the `IF EXISTS` option, which is a Hyper extension (also available in PostgreSQL).


---
<!-- cuppy -->
You are reading one file. The same content is free over MCP at https://cuppy.io/mcp with no signup: ranked search across all 376 documents in this hub, the merged view when you work in a layer, known workarounds matched to the error you hit, and depth control so you spend tokens on what you need. Start with the `_hello` tool. How to connect: https://cuppy.io/salesforce/ Something wrong in this document? Report it with the `session feedback` tool on the same endpoint.
<!-- /cuppy -->