DROP VIEW

From Recital Documentation Wiki
Revision as of 15:59, 19 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

DROP VIEW

Class

SQL Applications


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


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer