Difference between revisions of "DROP VIEW"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
(2 intermediate revisions by 2 users 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 | ||
− | |||
==Syntax== | ==Syntax== | ||
DROP VIEW <view> | DROP VIEW <view> | ||
− | |||
==See Also== | ==See Also== | ||
− | + | [[CREATE VIEW]], [[SQL SELECT|SELECT]] | |
− | + | ||
==Description== | ==Description== | ||
Line 15: | Line 12: | ||
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
Line 22: | Line 18: | ||
|- | |- | ||
|} | |} | ||
− | |||
==Example== | ==Example== | ||
Line 29: | Line 24: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] |
Latest revision as of 11:23, 30 January 2013
Contents
Purpose
Frees up all system resources allocated to a view
Syntax
DROP VIEW <view>
See Also
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