Release 10.1A: OpenEdge Data Management:
SQL Reference

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

> Example

>     DROP VIEW newcustomers ;

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

> ##### Authorization

> Must have `DBA` privilege or ownership of the view.

> ##### Related statements

> CREATE VIEW

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095