DROP VIEW
Function
DROP VIEW forcibly deletes a view from the database.
Precautions
Only the view owner or a user granted with the DROP permission can run the DROP VIEW command. The system administrator has this permission by default.
Syntax
DROP VIEW [ IF EXISTS ] view_name [, ...] [ CASCADE | RESTRICT ];
Parameter Description
IF EXISTS
Reports a notice instead of an error if the specified view does not exist.
view_name
Specifies the name of the view to be deleted.
Value range: an existing view name
CASCADE | RESTRICT
- CASCADE: automatically deletes the objects (such as other views) that depend on the view.
- RESTRICT: refuses to delete the view if any objects depend on it. This is the default action.
Examples
See Examples in CREATE VIEW.
Helpful Links
Feedback