# Presto 316 Documentation

## 9.18. DROP SCHEMA

## Synopsis

    DROP SCHEMA [ IF EXISTS ] schema_name

## Description

Drop an existing schema. The schema must be empty.

The optional `IF EXISTS` clause causes the error to be suppressed if the schema does not exist.

## Examples

Drop the schema `web`:

    DROP SCHEMA web

Drop the schema `sales` if it exists:

    DROP TABLE IF EXISTS sales

## See Also

ALTER SCHEMA, CREATE SCHEMA