From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- doc/src/sgml/ref/drop_schema.sgml | 131 ++++++++++++++++++++++++++++++++++++++ 1 file changed, 131 insertions(+) create mode 100644 doc/src/sgml/ref/drop_schema.sgml (limited to 'doc/src/sgml/ref/drop_schema.sgml') diff --git a/doc/src/sgml/ref/drop_schema.sgml b/doc/src/sgml/ref/drop_schema.sgml new file mode 100644 index 0000000..4d5d9f5 --- /dev/null +++ b/doc/src/sgml/ref/drop_schema.sgml @@ -0,0 +1,131 @@ + + + + + DROP SCHEMA + + + + DROP SCHEMA + 7 + SQL - Language Statements + + + + DROP SCHEMA + remove a schema + + + + +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 they do 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. + + + + + + name + + + The name of a schema. + + + + + + CASCADE + + + Automatically drop objects (tables, functions, etc.) that are + contained in the schema, + and in turn all objects that depend on those objects + (see ). + + + + + + RESTRICT + + + Refuse to drop the schema if it contains any objects. This is + the default. + + + + + + + + Notes + + + Using the CASCADE option might make the command + remove objects in other schemas besides the one(s) named. + + + + + Examples + + + To remove schema mystuff from the database, + along with everything it contains: + + +DROP SCHEMA mystuff CASCADE; + + + + + Compatibility + + + DROP SCHEMA is fully conforming with the SQL + standard, except that the standard only allows one schema to be + dropped per command, and apart from the + IF EXISTS option, which is a PostgreSQL + extension. + + + + + See Also + + + + + + + + -- cgit v1.2.3