SQL-J Language Reference
Page 29 of 121

DROP VIEW statement

Drops the specified view.

Syntax

DROP VIEW ViewName

Example

DROP VIEW Segments_SeatBookings

Dependency System

Any statements referencing the view are invalidated on a DROP VIEW statement. DROP VIEW is disallowed if there are any views or open cursors dependent on the view. The view must be dropped before any objects that it is dependent on can be dropped.