DROP VIEW

Deletes the view from the database.

Syntax

DROP VIEW [owner_name.]view_name ;

owner_name

Specifies the owner of the view.

view_name

Names the view to drop.

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.

The following is an example of the DROP VIEW statement:

DROP VIEW newcustomers ;

In this section: