---
cuppy_hub: salesforce
cuppy_path: reference/official/data360/data-cloud-query-guide/references/dc-sql-reference/drop-schema.md
cuppy_section: docs
cuppy_doc: 5KKK-H7X3
cuppy_doc_uuid: f922898c-553b-4861-9a6c-1d1beb10dff3
cuppy_permalink: https://cuppy.io/salesforce/d/5KKK-H7X3
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-schema
cuppy_mcp: https://cuppy.io/mcp
cuppy_body_sha256: 034e3fb0e96e31954377aed0af88a0b53fa261f1c905a0e1b79f2d19c1e74d1b
# 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-schema.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 SCHEMA

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

Remove a schema.

`DROP SCHEMA` removes one or more schemas from the database.

A schema can only be dropped by its owner or a superuser.

`IF EXISTS`
Do not throw an error if the schema does not exist. A notice is issued in this case.

`<name>`
The name of a schema.

`CASCADE`
Automatically drop objects (tables, functions, etc.) that are contained in the schema, and in turn all objects that depend on those objects.

`RESTRICT`
Refuse to drop the schema if it contains any objects. This is the default.

Using the `CASCADE` option might make the command remove objects in other schemas besides the one(s) named.

To remove schema `mystuff` from the database, along with everything it contains:

`DROP SCHEMA` is fully conforming with the SQL standard, except that the standard only allows one schema to be dropped per command, and apart from the `IF EXISTS` option, which is a Hyper extension.


---
<!-- 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 -->