Difference between revisions of "DROP VIEW"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (One intermediate revision by one user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==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 | + | 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
