Difference between revisions of "DROP VIEW"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Frees up all system resources allocated to a view
 
Frees up all system resources allocated to a view
Line 35: Line 31:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 16:58, 10 November 2009

Purpose

Frees up all system resources allocated to a view


Syntax

DROP VIEW <view>


See Also

Configuration Files, 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 Server, Recital