FirebirdSQL logo
 INDEXTRIGGER 

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

Example

Deleting the PRICE_WITH_MARKUP view
DROP VIEW PRICE_WITH_MARKUP;
See also

[fblangref50-ddl-view-create], [fblangref50-ddl-view-recreate], [fblangref50-ddl-view-crtoralter]