DROP SCHEMA¶
Drops a schema.
Synopsis¶
DROP SCHEMA [IF EXISTS] name [, ...] [ CASCADE | RESTRICT ]
Description¶
DROP SCHEMA is a DDL statement that drops one or more schemas.
Parameters¶
- name:
One or more schema names to drop, separated by
,.
Clauses¶
IF EXISTS¶
Do not raise an error if the schema is missing.
CASCADE¶
Drop all objects (tables, views, …) within the schema and all objects that depend on those.
RESTRICT¶
RESTRICTcausesDROP SCHEMAto raise an error if a schema still containsother objects (tables, views, UDFs). This is the default behavior.
See also