From 6eb9c5a5657d1fe77b55cc261450f3538d35a94d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 14:19:15 +0200 Subject: Adding upstream version 13.4. Signed-off-by: Daniel Baumann --- doc/src/sgml/html/sql-dropview.html | 29 +++++++++++++++++++++++++++++ 1 file changed, 29 insertions(+) create mode 100644 doc/src/sgml/html/sql-dropview.html (limited to 'doc/src/sgml/html/sql-dropview.html') diff --git a/doc/src/sgml/html/sql-dropview.html b/doc/src/sgml/html/sql-dropview.html new file mode 100644 index 0000000..ae3cb2f --- /dev/null +++ b/doc/src/sgml/html/sql-dropview.html @@ -0,0 +1,29 @@ + +DROP VIEW
DROP VIEW
Prev UpSQL CommandsHome Next

DROP VIEW

DROP VIEW — remove a view

Synopsis

+DROP VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
+

Description

+ DROP VIEW drops an existing view. To execute + this command you must be the owner of the view. +

Parameters

IF EXISTS

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

name

+ The name (optionally schema-qualified) of the view to remove. +

CASCADE

+ Automatically drop objects that depend on the view (such as + other views), + and in turn all objects that depend on those objects + (see Section 5.14). +

RESTRICT

+ Refuse to drop the view if any objects depend on it. This is + the default. +

Examples

+ This command will remove the view called kinds: +

+DROP VIEW kinds;
+

Compatibility

+ This command conforms to the SQL standard, except that the standard only + allows one view to be dropped per command, and apart from the + IF EXISTS option, which is a PostgreSQL + extension. +

Prev Up Next
DROP USER MAPPING Home END
\ No newline at end of file -- cgit v1.2.3