DROP VIEW

From Lianjapedia
Jump to: navigation, search

Purpose

Frees up all system resources allocated to a view

Syntax

DROP VIEW <view>

See Also

CREATE VIEW, SELECT

Description

The DROP VIEW command frees up all system resources allocated to the specified view and removes the view definition from the sysodbc.ini file in the current directory.


Keywords Description
view The name of the view to be dropped.

Example

DROP VIEW OverTen