Drop View
- Last Updated: July 30, 2025
- 1 minute read
- DataDirect Connectors
- ODBC
- MongoDB 8.0
- Documentation
Purpose
The Drop View statement drops a local view.
Note: This statement does not
affect native MongoDB views.
Syntax
DROP VIEW view_name [IF EXISTS] [RESTRICT | CASCADE]
where:
- view_name
- specifies the name of a view.
-
IF EXISTS - specifies that an error is not to be returned if the view does not exist.
-
RESTRICT - is in effect by default, meaning that the drop fails if any other view refers to this view.
-
CASCADE - silently drops all dependent local views.