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.
