Deletes the view from the database.

Syntax

DROP VIEW [owner_name.]view_name ;

Parameters

owner_name

Specifies the owner of the view.

view_name

Names the view to drop.

Notes

  • If owner_name is specified and is different from the name of the user executing the statement, then the user must have DBA privileges.
  • When a view is dropped, other views that are dependent on this view are not dropped. The dependent views become invalid.

Example

The following is an example of the DROP VIEW statement:

DROP VIEW newcustomers ;