DROP VIEW

The DROP VIEW statement removes the specified view.

If the view is replicated across an active standby pair and if DDL_REPLICATION_LEVEL is 3 or greater, the DROP VIEW statement drops the view from the active standby pair for all databases in the replication scheme. See Making DDL Changes in an Active Standby Pair in the Oracle TimesTen In-Memory Database Replication Guide for more information.

Required Privilege

View owner or DROP ANY VIEW (if not owner)

Usage with TimesTen Scaleout

This statement is supported with TimesTen Scaleout.

SQL Syntax

DROP VIEW [Owner.]ViewName

Parameters

Parameter	Description
`[Owner.]ViewName`	Identifies the view to be dropped.

Examples

The following statement drops the custorder view.

DROP VIEW custorder;