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.
