skip to main content
Supported SQL Statements and Extensions : Drop View
  

Try DataDirect Drivers Now

Drop View

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.