DROP SCHEMA

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

DROP SCHEMA

Removes a schema.

Synopsis

DROP SCHEMA [IF EXISTS] name [, ...] [CASCADE | RESTRICT]

Description

DROP SCHEMA removes schemas from the database. A schema can only be dropped by
its owner or a superuser. Note that the owner can drop the schema (and thereby all contained
objects) even if he does not own some of the objects within the schema.

Parameters

IF EXISTS

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