> ## Documentation Index
> Fetch the complete documentation index at: https://docs.kinetica.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DROP SCHEMA

Removes an existing [schema](/content/sql/ddl/create-schema#sql-create-schema).

```sql title="DROP SCHEMA Syntax" theme={null}
DROP SCHEMA [IF EXISTS] <schema name> [CASCADE]
```

## Parameters

<AccordionGroup>
  <Accordion title="IF EXISTS" id="if-exists" defaultOpen>
    Optional error-suppression clause; if specified, no error will be returned if the given
    *schema* does not exist
  </Accordion>

  <Accordion title="<schema name>" id="<schema-name>" defaultOpen>
    Name of the *schema* to remove
  </Accordion>

  <Accordion title="CASCADE" id="cascade" defaultOpen>
    Drops all objects contained within the schema; if not specified, an error will be returned if the
    given *schema* contains any *tables*, *views*, etc.
  </Accordion>
</AccordionGroup>

## Examples

To drop a *schema*, including all contained objects:

```sql DROP SCHEMA Example theme={null}
DROP SCHEMA example_container CASCADE
```