http://sqlzoo.net/w/index.php?title=DROP&feed=atom&action=history DROP - Revision history 2013-05-23T11:55:17Z Revision history for this page on the wiki MediaWiki 1.20.4 http://sqlzoo.net/w/index.php?title=DROP&diff=1482&oldid=prev Connor: Created page with " <h1>DROP</h1> <p>The table <code>games</code> shows the year and the city hosting the Olympic Games.</p> <table> <caption align='center'>games</caption> <tr><th align='center..." 2012-07-17T12:21:07Z <p>Created page with &quot; &lt;h1&gt;DROP&lt;/h1&gt; &lt;p&gt;The table &lt;code&gt;games&lt;/code&gt; shows the year and the city hosting the Olympic Games.&lt;/p&gt; &lt;table&gt; &lt;caption align=&#039;center&#039;&gt;games&lt;/caption&gt; &lt;tr&gt;&lt;th align=&#039;center...&quot;</p> <p><b>New page</b></p><div><br /> &lt;h1&gt;DROP&lt;/h1&gt;<br /> &lt;p&gt;The table &lt;code&gt;games&lt;/code&gt; shows the year and the city hosting the Olympic Games.&lt;/p&gt;<br /> &lt;table&gt;<br /> &lt;caption align='center'&gt;games&lt;/caption&gt;<br /> &lt;tr&gt;&lt;th align='center'&gt;'''yr'''&lt;/th&gt;&lt;th align='center'&gt;'''city'''&lt;/th&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2000&lt;/td&gt;&lt;td align='left'&gt;Sydney&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2004&lt;/td&gt;&lt;td align='left'&gt;Athens&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2008&lt;/td&gt;&lt;td align='left'&gt;Beijing&lt;/td&gt;&lt;/tr&gt;<br /> &lt;tr&gt;&lt;td&gt;2012&lt;/td&gt;&lt;td align='left'&gt;London&lt;/td&gt;&lt;/tr&gt;<br /> &lt;/table&gt;<br /> &lt;div class='ht'&gt;<br /> &lt;div class=params&gt;schema:scott&lt;/div&gt;<br /> &lt;source lang=sql class='tidy'&gt; DROP TABLE games&lt;/source&gt;<br /> &lt;source lang=sql class='setup'&gt; CREATE TABLE games(<br /> yr INTEGER PRIMARY KEY,<br /> city VARCHAR(20));<br /> INSERT INTO games VALUES (2000,'Sydney');<br /> INSERT INTO games VALUES (2004,'Athens');<br /> INSERT INTO games VALUES (2008,'Beijing');<br /> INSERT INTO games VALUES (2012,'London');<br /> &lt;/source&gt;<br /> You can drop a table, a view or an index. The data will be lost. <br /> &lt;source lang='sql' class='def e-oracle'&gt;<br /> DROP VIEW old_games;<br /> DROP INDEX gamesIdx ON scott.games;<br /> &lt;/source&gt; <br /> &lt;source lang='sql' class='def'&gt;<br /> DROP VIEW old_games;<br /> DROP INDEX gamesIdx ON games;<br /> &lt;/source&gt;<br /> &lt;/div&gt;<br /> <br /> &lt;p&gt;See also&lt;/p&gt;<br /> &lt;ul&gt;<br /> &lt;li&gt;[[CREATE_TABLE |CREATE]]&lt;/li&gt;<br /> &lt;li&gt;[[DELETE |DELETE]]&lt;/li&gt;<br /> &lt;/ul&gt;</div> Connor