SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-130
DROP VIEW Statement
DROP VIEW Statement
Considerations for DROP VIEW
Examples of DROP VIEW
The DROP VIEW statement deletes an SQL/MX view. See Views on page 6-108.
Syntax Description of DROP VIEW
view
is the name of the view to drop. 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. If you specify CASCADE, any such
dependent objects are dropped. The default is RESTRICT.
Considerations for DROP VIEW
Authorization and Availability Requirements
To drop a view, you must own the schema that contains the view or be the super ID.
Examples of DROP VIEW
•
This example drops a view:
DROP VIEW mycat.mysch.myview RESTRICT;
DROP VIEW view [CASCADE | RESTRICT]