FirebirdSQL logo
 INDEXTRIGGER 

DROP VIEW

Drops a view

Available in

DSQL

Syntax
DROP VIEW viewname
Table 1. DROP VIEW Statement Parameter
Parameter Description

viewname

View name

The DROP VIEW statement drops (deletes) an existing view.The statement will fail if the view has dependencies.

Who Can Drop a View?

The DROP VIEW statement can be executed by:

  • Administrators

  • The owner of the view

  • Users with the DROP ANY VIEW privilege