Drop View
- Last Updated: May 15, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
Purpose
Drops a view.
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 views.