---
schema_version: "1"
id: a4f9e6eba6e4551ad0a21f78893fa58dbd7849d10390dc7aa2b300eaac788bc3
title: DROP SCHEMA
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/drop-schema.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/drop-schema.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: 210028fe4498e6cb5f80e43480a13aaaf8630d36cb61e3ea9bd8849840c5c0bd
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# DROP SCHEMA

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

Remove a schema.

## Syntax

```sql
DROP SCHEMA [IF EXISTS] <name> [, ...] [ CASCADE | RESTRICT ]
```

## Description

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

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

## Parameters

- `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.

## Notes

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

## Examples

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

```sql
    DROP SCHEMA mystuff CASCADE;
```

## Compatibility

`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.

## See Also