| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475 |
- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
- <html><head>
- <title>SQLite Query Language: REINDEX</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>REINDEX</h1><h4><a href="syntaxdiagrams.html#reindex-stmt">reindex-stmt:</a></h4><blockquote> <img alt="syntax diagram reindex-stmt" src="images/syntax/reindex-stmt.gif"></img> </blockquote>
- <p>The REINDEX command is used to delete and recreate indices from scratch.
- This is useful when the definition of a collation sequence has changed.
- </p>
- <p>In the first form, all indices in all attached databases that use the
- named collation sequence are recreated. In the second form, if
- <i>[database-name.]table/index-name</i> identifies a table,
- then all indices
- associated with the table are rebuilt. If an index is identified, then only
- this specific index is deleted and recreated.
- </p>
- <p>If no <i>database-name</i> is specified and there exists both a table or
- index and a collation sequence of the specified name, then indices associated
- with the collation sequence only are reconstructed. This ambiguity may be
- dispelled by always specifying a <i>database-name</i> when reindexing a
- specific table or index.
|
