DROP VIEW

DROP VIEW statement is used to remove one or more views.

DROP VIEW [IF EXISTS]
    : view_name {, view_name}*
      [RESTRICT | CASCADE]

[IF EXISTS]

this clause prevents error if a view with the given name not exists, but warning still is generated for each non-existent view.

view_name

specifies the name of a view to be dropped.

[RESTRICT | CASCADE]

if given, are parsed and ignored.

• 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.

DROP VIEW wTeacher;