ALLBASE/SQL Reference Manual > Chapter 10 SQL Statements A - D

DROP VIEW

	MPE documents
	Complete PDF
	Table of Contents
	Index

	E0300 Edition 9 ♥
	E0399 Edition 8
	E0897 Edition 7

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

DROP TEMPSPACE

Chapter 11 SQL Statements E - R