DROP VIEW Command
Deletes a SQL view from the current database.
DROP VIEW ViewName
- Specifies the name of the view deleted from the current database.
DROP VIEW is identical to DELETE VIEW; DROP VIEW is the ANSI SQL standard syntax for deleting a SQL view.
Use CREATE SQL VIEW to create a SQL view and add the view to the current database. If a SQL view is opened and then deleted, the cursors containing the SQL view results are not closed.