Table of Contents
DROP VIEW
DROP VIEW statement is used to remove one or more views.
Syntax
DROP VIEW [IF EXISTS] view_name, ... [RESTRICT | CASCADE]
Arguments
[IF EXISTS]
this clause prevents error if a view with the given name does not exist, but a warning is still generated for each non-existent view.
view_name
specifies the name of the view to delete.
[RESTRICT | CASCADE]
if given, are parsed and ignored.
Possible Errors
- If any of the views named in the argument list do not exist, error is returned indicating by name which non-existing views it was unable to drop, but it also drops all of the views in the list that do exist.
Examples
DROP VIEW wTeacher;