Neoview SQL Reference Manual (R2.2)

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 254).
DROP VIEW view
Syntax Description of DROP VIEW
view
is the name of the view to drop.
Considerations for DROP VIEW
Authorization and Availability Requirements
To drop a view, you must own the schema that contains the view.
Example of DROP VIEW
• This example drops a view:
DROP VIEW mysch.myview;
100 SQL Statements