ALLBASE/SQL Reference Manual (36216-90216)

Chapter 10 409
SQL Statements A - D
DROP VIEW
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