Delete a view.




<drop view statement> ::=




DROP VIEW [ IF EXISTS ] [ schema-name. ] view-name [ RESTRICT ]





The DROP VIEW statement deletes the view specified by view-name from the database.





The current database is implicit if a schema name is not specified.


The IF EXISTS clause can be specified to avoid an exception when attempting to delete a view that does not exist in the database.


RESTRICT, which is implicit if not explicitly specified, prevents the view from being deleted if the view is referenced by other database objects.


The DROP VIEW statement requires exclusive access to the view being deleted.






The following example deletes the teachers_view view:


DROP VIEW IF EXISTS teachers_view






SQL:2003 standard


NexusDB extensions




Core SQL


IF EXISTS clause