| 12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970 |
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
- <html><head>
- <title>SQLite Query Language: DROP INDEX</title>
- <style type="text/css">
- body {
- margin: auto;
- font-family: Verdana, sans-serif;
- padding: 8px 1%;
- }
- a { color: #45735f }
- a:visited { color: #734559 }
- .logo { position:absolute; margin:3px; }
- .tagline {
- float:right;
- text-align:right;
- font-style:italic;
- width:240px;
- margin:12px;
- margin-top:58px;
- }
- .toolbar {
- font-variant: small-caps;
- text-align: center;
- line-height: 1.6em;
- margin: 0;
- padding:1px 8px;
- }
- .toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
- .toolbar a:visited { color: white; }
- .toolbar a:hover { color: #80a796; background: white; }
- .content { margin: 5%; }
- .content dt { font-weight:bold; }
- .content dd { margin-bottom: 25px; margin-left:20%; }
- .content ul { padding:0px; padding-left: 15px; margin:0px; }
- /* rounded corners */
- .se { background: url(images/se.png) 100% 100% no-repeat #80a796}
- .sw { background: url(images/sw.png) 0% 100% no-repeat }
- .ne { background: url(images/ne.png) 100% 0% no-repeat }
- .nw { background: url(images/nw.png) 0% 0% no-repeat }
- </style>
- <meta http-equiv="content-type" content="text/html; charset=UTF-8">
-
- </head>
- <body>
- <div><!-- container div to satisfy validator -->
- <a href="lang.html">
- <h2 align="center">SQL As Understood By SQLite</h2></a><h1>DROP INDEX</h1><h4><a href="syntaxdiagrams.html#drop-index-stmt">drop-index-stmt:</a></h4><blockquote> <img alt="syntax diagram drop-index-stmt" src="images/syntax/drop-index-stmt.gif"></img> </blockquote>
- <p>The DROP INDEX statement removes an index added
- with the <a href="lang_createindex.html">CREATE INDEX</a> statement. The index named is completely removed from
- the disk. The only way to recover the index is to reenter the
- appropriate <a href="lang_createindex.html">CREATE INDEX</a> command.</p>
- <p>The DROP INDEX statement does not reduce the size of the database
- file in the default mode.
- Empty space in the database is retained for later <a href="lang_insert.html">INSERT</a> statements. To
- remove free space in the database, use the <a href="lang_vacuum.html">VACUUM</a>
- command. If <a href="pragma.html#pragma_auto_vacuum">auto_vacuum</a> mode is enabled for a database then space
- will be freed automatically by DROP INDEX.</p>
|
