DROP SCHEMA#
Synopsis#
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 the schema sales
if it exists:
Drop the schema archive
, along with everything it contains:
Drop the schema archive
, only if there are no objects contained in the schema: