Small. Fast. Reliable.
Choose any three.

SQLite Requirement Matrix Details
lang_reindex.html

Index Summary Markup Original


R-63170-45646-47939-24773-60116-07390-12399-34269 tcl slt th3 src

Canonical usage: syntax/reindex-stmt.html

th3/cov1/build24.test:51

/* IMP: R-63170-45646 */
# EVIDENCE-OF: R-63170-45646 -- syntax diagram reindex-stmt

R-52173-44778-34853-40579-46358-28940-10008-53316 tcl slt th3 src

The REINDEX command is used to delete and recreate indices from scratch.

slt/slt_lang_reindex.test:34   tcl/e_reindex.test:41

/* IMP: R-52173-44778 */
# EVIDENCE-OF: R-52173-44778 The REINDEX command is used to delete and
# recreate indices from scratch.

R-47362-07898-57690-63362-38950-19612-46458-01308 tcl slt th3 src

If the REINDEX keyword is not followed by a collation-sequence or database object identifier, then all indices in all attached databases are rebuilt.

tcl/e_reindex.test:161

/* IMP: R-47362-07898 */
# EVIDENCE-OF: R-47362-07898 If the REINDEX keyword is not followed by a
# collation-sequence or database object identifier, then all indices in
# all attached databases are rebuilt.

R-45878-07697-09901-50980-47387-13868-52582-57913 tcl slt th3 src

If the REINDEX keyword is followed by a collation-sequence name, then all indices in all attached databases that use the named collation sequences are recreated.

tcl/e_reindex.test:174

/* IMP: R-45878-07697 */
# EVIDENCE-OF: R-45878-07697 If the REINDEX keyword is followed by a
# collation-sequence name, then all indices in all attached databases
# that use the named collation sequences are recreated.

R-49616-30196-22472-11090-21986-31770-01648-15576 tcl slt th3 src

Or, if the argument attached to the REINDEX identifies a specific database table, then all indices attached to the database table are rebuilt.

tcl/e_reindex.test:194

/* IMP: R-49616-30196 */
# EVIDENCE-OF: R-49616-30196 Or, if the argument attached to the REINDEX
# identifies a specific database table, then all indices attached to the
# database table are rebuilt.

R-58823-28748-40734-32181-06103-05121-55072-03563 tcl slt th3 src

If it identifies a specific database index, then just that index is recreated.

tcl/e_reindex.test:221

/* IMP: R-58823-28748 */
# EVIDENCE-OF: R-58823-28748 If it identifies a specific database index,
# then just that index is recreated.

R-35892-30289-55875-11491-60713-08800-59610-09295 tcl slt th3 src

For a command of the form "REINDEX name", a match against collation-name takes precedence over a match against index-name or table-name.

tcl/e_reindex.test:268

/* IMP: R-35892-30289 */
# EVIDENCE-OF: R-35892-30289 For a command of the form "REINDEX name", a
# match against collation-name takes precedence over a match against
# index-name or table-name.