简体中文

DROP SCHEMA

Delete mode.

Synopsis

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

Description

DROP SCHEMA deletes schema from database. The mode can only be removed by its owner or superuser. Note that even if the owner does not own some objects within the schema, the owner can delete the schema (and thus all contained objects).

Parameters

IF EXISTS

If this mode does not exist, please do not report an error. In this case, a notification will be issued.

name

The name of the pattern to be deleted.

CASCADE

Automatically delete all objects (tables, functions, etc.) contained in the schema.

RESTRICT

If the pattern contains any object, the pattern is denied. This is the default value.

Example

Remove schema mystuff from the database and everything it contains:

DROP SCHEMA mystuff CASCADE;

Compatibility

DROP SCHEMA is fully compliant with the SQL standard, but this standard allows only one pattern per command to be deleted. Additionally, the IF EXISTS option is a YMatrix database extension.