HP 3000 Manuals

ALLBASE/SQL Reference Manual

DROP VIEW 

The DROP VIEW statement deletes the definition of the specified view from
the system catalog, all authorization granted on the view, and any view
that references the dropped view.

Scope 

ISQL or Application Programs

SQL Syntax 

DROP VIEW [Owner.]ViewName 

Parameters 

[Owner.]ViewName        identifies the view to be dropped.

Description 

   *   This statement does not affect the base tables on which the views
       were defined.

   *   The DROP VIEW statement can invalidate stored sections.  Refer to
       the ALLBASE/SQL Database Administration Guide for additional
       information on stored section validation.

   *   You cannot use this statement on system views.

   *   If the view was defined with a WITH CHECK OPTION constraint, the
       view check constraint is also deleted.

Authorization 

You can use the DROP VIEW statement if you have OWNER authority for the
view or if you have DBA authority.

Example 

The view is dropped.  Any grants referencing the view are automatically
revoked.

     DROP VIEW ReorderParts

MPE/iX 5.5 Documentation