Neoview SQL Reference Manual (R2.3)

DROP VIEW Statement
• “Syntax Description of DROP VIEW”
• “Considerations for DROP VIEW”
• “Example of DROP VIEW”
The DROP VIEW statement deletes a Neoview SQL view. See “Views” (page 264).
DROP VIEW view [RESTRICT|CASCADE]
Syntax Description of DROP VIEW
view
is the name of the view to delete.
RESTRICT
If you specify RESTRICT, you cannot drop the specified view if it is referenced in the query
expression of any other view or in the search condition of another object's constraint. The
default is RESTRICT.
CASCADE
If you specify CASCADE, any dependent objects are dropped.
Considerations for DROP VIEW
Authorization and Availability Requirements
To drop a view, you must be the owner of the view or owner of the schema.
Example of DROP VIEW
• This example drops a view:
DROP VIEW mysch.myview;
102 SQL Statements