1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
|
<!DOCTYPE html>
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="sqlite.css" rel="stylesheet">
<title>SQLite Site Map</title>
<!-- path= -->
</head>
<body>
<div class=nosearch>
<a href="index.html">
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
<div class="tagline desktoponly">
Small. Fast. Reliable.<br>Choose any three.
</div>
<div class="menu mainmenu">
<ul>
<li><a href="index.html">Home</a>
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
<li class='wideonly'><a href='about.html'>About</a>
<li class='desktoponly'><a href="docs.html">Documentation</a>
<li class='desktoponly'><a href="download.html">Download</a>
<li class='wideonly'><a href='copyright.html'>License</a>
<li class='desktoponly'><a href="support.html">Support</a>
<li class='desktoponly'><a href="prosupport.html">Purchase</a>
<li class='search' id='search_menubutton'>
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
</ul>
</div>
<div class="menu submenu" id="submenu">
<ul>
<li><a href='about.html'>About</a>
<li><a href='docs.html'>Documentation</a>
<li><a href='download.html'>Download</a>
<li><a href='support.html'>Support</a>
<li><a href='prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="search">
<select name="s" id="searchtype">
<option value="d">Search Documentation</option>
<option value="c">Search Changelog</option>
</select>
<input type="text" name="q" id="searchbox" value="">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
var w = document.getElementById(nm);
if( w.style.display=="block" ){
w.style.display = "none";
}else{
w.style.display = "block";
}
}
function toggle_search() {
var w = document.getElementById("searchmenu");
if( w.style.display=="block" ){
w.style.display = "none";
} else {
w.style.display = "block";
setTimeout(function(){
document.getElementById("searchbox").focus()
}, 30);
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
function hideorshow(btn,obj){
var x = document.getElementById(obj);
var b = document.getElementById(btn);
if( x.style.display!='none' ){
x.style.display = 'none';
b.innerHTML='show';
}else{
x.style.display = '';
b.innerHTML='hide';
}
return false;
}
var antiRobot = 0;
function antiRobotGo(){
if( antiRobot!=3 ) return;
antiRobot = 7;
var j = document.getElementById("mtimelink");
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
}
function antiRobotDefense(){
document.body.onmousedown=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousedown=null;
}
document.body.onmousemove=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousemove=null;
}
setTimeout(function(){
antiRobot |= 1;
antiRobotGo();
}, 100)
antiRobotGo();
}
antiRobotDefense();
</script>
<h2>Permuted Index</h2>
<var class="rightsidebar border2px desktoponly">
Other Documentation Indices:
<ul>
<li><a href="docs.html">Categorical Document List</a>
<li><a href="books.html">Books About SQLite</a>
<li><a href="doclist.html">Alphabetical List Of Documents</a>
<li><a href="keyword_index.html">Website Keyword Index</a>
</ul>
</var>
<ul class='lessindent'>
<li><b><a href="fasterthanfs.html">35% Faster Than The Filesystem</a></b></li>
<li><b><a href="shortnames.html">8+3 Filenames</a></b></li>
<li><b><a href="about.html">About SQLite</a></b></li>
<li><a href="books.html">About SQLite — Books</a></li>
<li><a href="flextypegood.html">Advantages Of Flexible Typing — The</a></li>
<li><a href="security.html">Against The Dark Arts — Defense</a></li>
<li><a href="lang_aggfunc.html">Aggregate Functions — Built in</a></li>
<li><a href="wal.html">Ahead Logging — Write</a></li>
<li><a href="malloc.html">Allocation In SQLite — Dynamic Memory</a></li>
<li><b><a href="doclist.html">Alphabetical List Of SQLite Documents</a></b></li>
<li><b><a href="lang_altertable.html">ALTER TABLE</a></b></li>
<li><a href="amalgamation.html">Amalgamation — The SQLite</a></li>
<li><b><a href="asyncvfs.html">An Asynchronous I/O Module For SQLite</a></b></li>
<li><b><a href="cintro.html">An Introduction To The SQLite C/C++ Interface</a></b></li>
<li><b><a href="lang_analyze.html">ANALYZE</a></b></li>
<li><a href="lockingv3.html">And Concurrency In SQLite Version 3 — File Locking</a></li>
<li><a href="useovernet.html">and Considerations — SQLite Over a Network, Caveats</a></li>
<li><a href="rescode.html">and Error Codes — Result</a></li>
<li><a href="fts3.html">and FTS4 Extensions — SQLite FTS3</a></li>
<li><a href="quirks.html">and Gotchas In SQLite — Quirks, Caveats,</a></li>
<li><a href="json1.html">And Operators — JSON Functions</a></li>
<li><a href="cpu.html">and Reducing CPU Usage in SQLite — Measuring</a></li>
<li><a href="bytecodevtab.html">And Tables_Used() Table Valued Functions — The Bytecode()</a></li>
<li><a href="withoutrowid.html">and the WITHOUT ROWID Optimization — Clustered Indexes</a></li>
<li><a href="lang_datefunc.html">And Time Functions — Date</a></li>
<li><a href="errlog.html">And Warning Log — The Error</a></li>
<li><b><a href="https://sqlite.org/android/">Android Bindings</a></b></li>
<li><a href="backup.html">API — SQLite Backup</a></li>
<li><a href="unlock_notify.html">API — SQLite Unlock Notify</a></li>
<li><a href="capi3ref.html">API Reference — C/C++</a></li>
<li><b><a href="appfunc.html">Application Defined SQL Functions</a></b></li>
<li><a href="appfileformat.html">Application File Format — SQLite As An</a></li>
<li><a href="threadsafe.html">Applications — Using SQLite In Multi Threaded</a></li>
<li><b><a href="whentouse.html">Appropriate Uses For SQLite</a></b></li>
<li><b><a href="arch.html">Architecture of SQLite</a></b></li>
<li><a href="sqlar.html">Archive Files — SQLite</a></li>
<li><a href="https://sqlite.org/sqlar/">Archiver (sqlar.exe) — SQLite</a></li>
<li><a href="np1queryprob.html">Are Efficient In SQLite — Many Small Queries</a></li>
<li><a href="security.html">Arts — Defense Against The Dark</a></li>
<li><a href="faq.html">Asked Questions — SQLite Frequently</a></li>
<li><a href="assert.html">assert() In SQLite — The Use Of</a></li>
<li><a href="asyncvfs.html">Asynchronous I/O Module For SQLite — An</a></li>
<li><b><a href="atomiccommit.html">Atomic Commit In SQLite</a></b></li>
<li><b><a href="lang_attach.html">ATTACH DATABASE</a></b></li>
<li><a href="autoinc.html">Autoincrement — SQLite</a></li>
<li><b><a href="undoredo.html">Automatic Undo/Redo With SQLite</a></b></li>
<li><a href="backup.html">Backup API — SQLite</a></li>
<li><b><a href="aff_short.html">Benefits of SQLite As A File Format</a></b></li>
<li><a href="https://sqlite.org/android/">Bindings — Android</a></li>
<li><a href="intern-v-extern-blob.html">BLOBs — Internal Versus External</a></li>
<li><b><a href="books.html">Books About SQLite</a></b></li>
<li><a href="privatebranch.html">Branches Of SQLite — Maintaining Private</a></li>
<li><a href="custombuild.html">Builds Of SQLite — Custom</a></li>
<li><b><a href="lang_aggfunc.html">Built in Aggregate Functions</a></b></li>
<li><b><a href="lang_mathfunc.html">Built In Mathematical SQL Functions</a></b></li>
<li><a href="printf.html">Built in printf() — SQLite's</a></li>
<li><b><a href="lang_corefunc.html">Built In Scalar SQL Functions</a></b></li>
<li><a href="opcode.html">Bytecode Engine — The SQLite</a></li>
<li><a href="bytecodevtab.html">Bytecode() And Tables_Used() Table Valued Functions — The</a></li>
<li><b><a href="capi3ref.html">C/C++ API Reference</a></b></li>
<li><a href="cintro.html">C/C++ Interface — An Introduction To The SQLite</a></li>
<li><a href="session.html">C/C++ Interface — SQLite Session Module</a></li>
<li><b><a href="capi3ref.html">C/C++ Interface For SQLite Version 3</a></b></li>
<li><b><a href="capi3.html">C/C++ Interface For SQLite Version 3 (old)</a></b></li>
<li><a href="sharedcache.html">Cache Mode — SQLite Shared</a></li>
<li><a href="getthecode.html">Canonical SQLite Source Code — How To Download</a></li>
<li><a href="carray.html">Carray() Table Valued Function — The</a></li>
<li><a href="useovernet.html">Caveats and Considerations — SQLite Over a Network,</a></li>
<li><a href="quirks.html">Caveats, and Gotchas In SQLite — Quirks,</a></li>
<li><b><a href="pgszchng2016.html">Change in Default Page Size in SQLite Version 3.12.0</a></b></li>
<li><a href="34to35.html">Changes From Version 3.4.2 To 3.5.0 — SQLite</a></li>
<li><a href="35to36.html">Changes From Version 3.5.9 To 3.6.0 — SQLite</a></li>
<li><a href="formatchng.html">Changes in SQLite — File Format</a></li>
<li><a href="nulinstr.html">Characters In Strings — NUL</a></li>
<li><a href="cksumvfs.html">Checksum VFS Shim — The</a></li>
<li><a href="lang_indexedby.html">Clause — The INDEXED BY</a></li>
<li><a href="lang_conflict.html">Clause — The ON CONFLICT</a></li>
<li><a href="lang_with.html">Clause — The WITH</a></li>
<li><b><a href="withoutrowid.html">Clustered Indexes and the WITHOUT ROWID Optimization</a></b></li>
<li><a href="getthecode.html">Code — How To Download Canonical SQLite Source</a></li>
<li><a href="whyc.html">Coded In C — Why Is SQLite</a></li>
<li><a href="rescode.html">Codes — Result and Error</a></li>
<li><a href="uintcseq.html">Collating Sequence — The UINT</a></li>
<li><a href="gencol.html">Columns — Generated</a></li>
<li><b><a href="cli.html">Command Line Shell For SQLite</a></b></li>
<li><a href="lang_comment.html">Comment Syntax — SQL</a></li>
<li><a href="atomiccommit.html">Commit In SQLite — Atomic</a></li>
<li><a href="speed.html">Comparison — SQLite Database Speed</a></li>
<li><a href="howtocompile.html">Compile SQLite — How To</a></li>
<li><b><a href="compile.html">Compile time Options</a></b></li>
<li><a href="completion.html">COMPLETION() Table Valued Function — The</a></li>
<li><a href="lockingv3.html">Concurrency In SQLite Version 3 — File Locking And</a></li>
<li><a href="zeroconf.html">Configuration — Zero</a></li>
<li><a href="lang_conflict.html">CONFLICT Clause — The ON</a></li>
<li><a href="conflict.html">Conflict Resolution in SQLite — Constraint</a></li>
<li><a href="useovernet.html">Considerations — SQLite Over a Network, Caveats and</a></li>
<li><a href="consortium.html">Consortium — SQLite</a></li>
<li><b><a href="conflict.html">Constraint Conflict Resolution in SQLite</a></b></li>
<li><a href="selfcontained.html">Contained System — SQLite is a Self</a></li>
<li><a href="https://www.fossil-scm.org/">Control System — The Fossil Version</a></li>
<li><a href="copyright.html">Copyright — SQLite</a></li>
<li><a href="howtocorrupt.html">Corrupt An SQLite Database File — How To</a></li>
<li><a href="recovery.html">Corrupt SQLite Database — Recovering Data From A</a></li>
<li><a href="cpu.html">CPU Usage in SQLite — Measuring and Reducing</a></li>
<li><b><a href="lang_createindex.html">CREATE INDEX</a></b></li>
<li><b><a href="lang_createtable.html">CREATE TABLE</a></b></li>
<li><b><a href="lang_createtrigger.html">CREATE TRIGGER</a></b></li>
<li><b><a href="lang_createview.html">CREATE VIEW</a></b></li>
<li><b><a href="lang_createvtab.html">CREATE VIRTUAL TABLE</a></b></li>
<li><a href="csv.html">CSV Virtual Table — The</a></li>
<li><b><a href="custombuild.html">Custom Builds Of SQLite</a></b></li>
<li><a href="security.html">Dark Arts — Defense Against The</a></li>
<li><a href="recovery.html">Data From A Corrupt SQLite Database — Recovering</a></li>
<li><a href="lang_attach.html">DATABASE — ATTACH</a></li>
<li><a href="recovery.html">Database — Recovering Data From A Corrupt SQLite</a></li>
<li><a href="onefile.html">Database — SQLite: Single File</a></li>
<li><a href="sqldiff.html">Database Difference Utility — sqldiff.exe:</a></li>
<li><a href="mostdeployed.html">Database Engine — Most Widely Deployed SQL</a></li>
<li><a href="vdbe.html">Database Engine of SQLite — The Virtual</a></li>
<li><a href="howtocorrupt.html">Database File — How To Corrupt An SQLite</a></li>
<li><b><a href="fileformat2.html">Database File Format</a></b></li>
<li><b><a href="lang_naming.html">Database Object Name Resolution</a></b></li>
<li><a href="speed.html">Database Speed Comparison — SQLite</a></li>
<li><a href="inmemorydb.html">Databases — In Memory</a></li>
<li><b><a href="datatype3.html">Datatypes In SQLite</a></b></li>
<li><b><a href="datatypes.html">Datatypes In SQLite version 2</a></b></li>
<li><b><a href="lang_datefunc.html">Date And Time Functions</a></b></li>
<li><a href="dbhash.html">dbhash.exe Utility Program — The</a></li>
<li><a href="dbstat.html">DBSTAT Virtual Table — The</a></li>
<li><a href="debugging.html">Debugging SQLite — Hints for</a></li>
<li><a href="pgszchng2016.html">Default Page Size in SQLite Version 3.12.0 — Change in</a></li>
<li><b><a href="security.html">Defense Against The Dark Arts</a></b></li>
<li><a href="appfunc.html">Defined SQL Functions — Application</a></li>
<li><b><a href="lang_delete.html">DELETE</a></b></li>
<li><a href="mostdeployed.html">Deployed SQL Database Engine — Most Widely</a></li>
<li><b><a href="lang_detach.html">DETACH</a></b></li>
<li><b><a href="deterministic.html">Deterministic SQL Functions</a></b></li>
<li><a href="crew.html">Developers — SQLite</a></li>
<li><a href="syntax.html">Diagrams — List of SQLite Syntax</a></li>
<li><a href="syntaxdiagrams.html">Diagrams For SQLite — Syntax</a></li>
<li><a href="sqldiff.html">Difference Utility — sqldiff.exe: Database</a></li>
<li><a href="fileformat2.html">Disk Format — On</a></li>
<li><b><a href="different.html">Distinctive Features Of SQLite</a></b></li>
<li><a href="docs.html">Documentation — SQLite</a></li>
<li><a href="doclist.html">Documents — Alphabetical List Of SQLite</a></li>
<li><a href="omitted.html">Does Not Implement — SQL Features That SQLite</a></li>
<li><a href="whynotgit.html">Does Not Use Git — Why SQLite</a></li>
<li><a href="getthecode.html">Download Canonical SQLite Source Code — How To</a></li>
<li><a href="download.html">Download Page — SQLite</a></li>
<li><b><a href="lang_dropindex.html">DROP INDEX</a></b></li>
<li><b><a href="lang_droptable.html">DROP TABLE</a></b></li>
<li><b><a href="lang_droptrigger.html">DROP TRIGGER</a></b></li>
<li><b><a href="lang_dropview.html">DROP VIEW</a></b></li>
<li><b><a href="malloc.html">Dynamic Memory Allocation In SQLite</a></b></li>
<li><a href="np1queryprob.html">Efficient In SQLite — Many Small Queries Are</a></li>
<li><a href="mostdeployed.html">Engine — Most Widely Deployed SQL Database</a></li>
<li><a href="opcode.html">Engine — The SQLite Bytecode</a></li>
<li><a href="vdbe.html">Engine of SQLite — The Virtual Database</a></li>
<li><a href="errlog.html">Error And Warning Log — The</a></li>
<li><a href="rescode.html">Error Codes — Result and</a></li>
<li><b><a href="lang_explain.html">EXPLAIN</a></b></li>
<li><b><a href="eqp.html">EXPLAIN QUERY PLAN</a></b></li>
<li><a href="expridx.html">Expressions — Indexes On</a></li>
<li><a href="lang_expr.html">Expressions — SQL Language</a></li>
<li><a href="fts5.html">Extension — SQLite FTS5</a></li>
<li><a href="rbu.html">Extension — The RBU</a></li>
<li><a href="sessionintro.html">Extension — The Session</a></li>
<li><a href="loadext.html">Extensions — Run Time Loadable</a></li>
<li><a href="fts3.html">Extensions — SQLite FTS3 and FTS4</a></li>
<li><a href="intern-v-extern-blob.html">External BLOBs — Internal Versus</a></li>
<li><a href="fasterthanfs.html">Faster Than The Filesystem — 35%</a></li>
<li><a href="fullsql.html">Featured SQL — Full</a></li>
<li><b><a href="features.html">Features Of SQLite</a></b></li>
<li><a href="different.html">Features Of SQLite — Distinctive</a></li>
<li><a href="omitted.html">Features That SQLite Does Not Implement — SQL</a></li>
<li><a href="howtocorrupt.html">File — How To Corrupt An SQLite Database</a></li>
<li><a href="onefile.html">File Database — SQLite: Single</a></li>
<li><a href="aff_short.html">File Format — Benefits of SQLite As A</a></li>
<li><a href="fileformat2.html">File Format — Database</a></li>
<li><a href="appfileformat.html">File Format — SQLite As An Application</a></li>
<li><a href="walformat.html">File Format — WAL mode</a></li>
<li><b><a href="formatchng.html">File Format Changes in SQLite</a></b></li>
<li><b><a href="lockingv3.html">File Locking And Concurrency In SQLite Version 3</a></b></li>
<li><a href="shortnames.html">Filenames — 8+3</a></li>
<li><a href="sqlar.html">Files — SQLite Archive</a></li>
<li><a href="tempfiles.html">Files Used By SQLite — Temporary</a></li>
<li><a href="fasterthanfs.html">Filesystem — 35% Faster Than The</a></li>
<li><a href="flextypegood.html">Flexible Typing — The Advantages Of</a></li>
<li><b><a href="floatingpoint.html">Floating Point Numbers</a></b></li>
<li><a href="footprint.html">Footprint — SQLite Library</a></li>
<li><a href="foreignkeys.html">Foreign Key Support — SQLite</a></li>
<li><a href="aff_short.html">Format — Benefits of SQLite As A File</a></li>
<li><a href="fileformat2.html">Format — Database File</a></li>
<li><a href="locrsf.html">Format — LoC Recommended Storage</a></li>
<li><a href="fileformat2.html">Format — On Disk</a></li>
<li><a href="appfileformat.html">Format — SQLite As An Application File</a></li>
<li><a href="walformat.html">Format — WAL mode File</a></li>
<li><a href="formatchng.html">Format Changes in SQLite — File</a></li>
<li><a href="https://www.fossil-scm.org/">Fossil Version Control System — The</a></li>
<li><a href="faq.html">Frequently Asked Questions — SQLite</a></li>
<li><a href="recovery.html">From A Corrupt SQLite Database — Recovering Data</a></li>
<li><a href="34to35.html">From Version 3.4.2 To 3.5.0 — SQLite Changes</a></li>
<li><a href="35to36.html">From Version 3.5.9 To 3.6.0 — SQLite Changes</a></li>
<li><a href="fts3.html">FTS3 and FTS4 Extensions — SQLite</a></li>
<li><a href="fts3.html">FTS4 Extensions — SQLite FTS3 and</a></li>
<li><a href="fts5.html">FTS5 Extension — SQLite</a></li>
<li><b><a href="fullsql.html">Full Featured SQL</a></b></li>
<li><a href="carray.html">Function — The Carray() Table Valued</a></li>
<li><a href="completion.html">Function — The COMPLETION() Table Valued</a></li>
<li><a href="series.html">Function — The generate_series Table Valued</a></li>
<li><a href="appfunc.html">Functions — Application Defined SQL</a></li>
<li><a href="lang_aggfunc.html">Functions — Built in Aggregate</a></li>
<li><a href="lang_mathfunc.html">Functions — Built In Mathematical SQL</a></li>
<li><a href="lang_corefunc.html">Functions — Built In Scalar SQL</a></li>
<li><a href="lang_datefunc.html">Functions — Date And Time</a></li>
<li><a href="deterministic.html">Functions — Deterministic SQL</a></li>
<li><a href="bytecodevtab.html">Functions — The Bytecode() And Tables_Used() Table Valued</a></li>
<li><a href="windowfunctions.html">Functions — Window</a></li>
<li><a href="json1.html">Functions And Operators — JSON</a></li>
<li><a href="series.html">generate_series Table Valued Function — The</a></li>
<li><b><a href="gencol.html">Generated Columns</a></b></li>
<li><a href="queryplanner-ng.html">Generation Query Planner — The Next</a></li>
<li><a href="lemon.html">Generator — The Lemon LALR(1) Parser</a></li>
<li><a href="geopoly.html">Geopoly Interface To The SQLite R*Tree Module — The</a></li>
<li><a href="whynotgit.html">Git — Why SQLite Does Not Use</a></li>
<li><a href="quirks.html">Gotchas In SQLite — Quirks, Caveats, and</a></li>
<li><a href="nulls.html">Handling in SQLite — NULL</a></li>
<li><b><a href="hirely.html">High Reliability</a></b></li>
<li><b><a href="debugging.html">Hints for Debugging SQLite</a></b></li>
<li><a href="changes.html">History Of SQLite — Release</a></li>
<li><b><a href="chronology.html">History Of SQLite Releases</a></b></li>
<li><a href="index.html">Home Page — SQLite</a></li>
<li><b><a href="queryplanner.html">How Indexes Work</a></b></li>
<li><b><a href="testing.html">How SQLite Is Tested</a></b></li>
<li><b><a href="howitworks.html">How SQLite Works</a></b></li>
<li><b><a href="howtocompile.html">How To Compile SQLite</a></b></li>
<li><b><a href="howtocorrupt.html">How To Corrupt An SQLite Database File</a></b></li>
<li><b><a href="getthecode.html">How To Download Canonical SQLite Source Code</a></b></li>
<li><a href="mmap.html">I/O — Memory Mapped</a></li>
<li><a href="asyncvfs.html">I/O Module For SQLite — An Asynchronous</a></li>
<li><a href="uri.html">Identifiers — Uniform Resource</a></li>
<li><a href="omitted.html">Implement — SQL Features That SQLite Does Not</a></li>
<li><b><a href="limits.html">Implementation Limits For SQLite</a></b></li>
<li><b><a href="imposter.html">Imposter Tables</a></b></li>
<li><b><a href="inmemorydb.html">In Memory Databases</a></b></li>
<li><a href="lang_createindex.html">INDEX — CREATE</a></li>
<li><a href="lang_dropindex.html">INDEX — DROP</a></li>
<li><a href="keyword_index.html">Index — Website Keyword</a></li>
<li><a href="lang_indexedby.html">INDEXED BY Clause — The</a></li>
<li><a href="partialindex.html">Indexes — Partial</a></li>
<li><a href="withoutrowid.html">Indexes and the WITHOUT ROWID Optimization — Clustered</a></li>
<li><b><a href="expridx.html">Indexes On Expressions</a></b></li>
<li><a href="queryplanner.html">Indexes Work — How</a></li>
<li><b><a href="lang_insert.html">INSERT</a></b></li>
<li><a href="cintro.html">Interface — An Introduction To The SQLite C/C++</a></li>
<li><a href="session.html">Interface — SQLite Session Module C/C++</a></li>
<li><a href="capi3ref.html">Interface For SQLite Version 3 — C/C++</a></li>
<li><a href="capi3.html">Interface For SQLite Version 3 (old) — C/C++</a></li>
<li><a href="vfs.html">Interface or VFS — The SQLite OS</a></li>
<li><a href="c_interface.html">interface to SQLite Version 2 — The C language</a></li>
<li><a href="tclsqlite.html">interface to the SQLite library — The Tcl</a></li>
<li><a href="geopoly.html">Interface To The SQLite R*Tree Module — The Geopoly</a></li>
<li><a href="bindptr.html">Interfaces — Pointer Passing</a></li>
<li><b><a href="intern-v-extern-blob.html">Internal Versus External BLOBs</a></b></li>
<li><a href="cintro.html">Introduction To The SQLite C/C++ Interface — An</a></li>
<li><b><a href="invalidutf.html">Invalid UTF Policy</a></b></li>
<li><b><a href="isolation.html">Isolation In SQLite</a></b></li>
<li><b><a href="hp1.html">Javascript Required</a></b></li>
<li><b><a href="json1.html">JSON Functions And Operators</a></b></li>
<li><a href="foreignkeys.html">Key Support — SQLite Foreign</a></li>
<li><a href="keyword_index.html">Keyword Index — Website</a></li>
<li><a href="lang_keywords.html">Keywords — SQLite</a></li>
<li><a href="famous.html">Known Users Of SQLite — Well</a></li>
<li><a href="lemon.html">LALR(1) Parser Generator — The Lemon</a></li>
<li><a href="lang_expr.html">Language Expressions — SQL</a></li>
<li><a href="c_interface.html">language interface to SQLite Version 2 — The C</a></li>
<li><a href="lang.html">Language Understood by SQLite — Query</a></li>
<li><a href="lemon.html">Lemon LALR(1) Parser Generator — The</a></li>
<li><a href="quickstart.html">Less — SQLite In 5 Minutes Or</a></li>
<li><a href="tclsqlite.html">library — The Tcl interface to the SQLite</a></li>
<li><a href="footprint.html">Library Footprint — SQLite</a></li>
<li><a href="limits.html">Limits For SQLite — Implementation</a></li>
<li><a href="cli.html">Line Shell For SQLite — Command</a></li>
<li><a href="doclist.html">List Of SQLite Documents — Alphabetical</a></li>
<li><b><a href="syntax.html">List of SQLite Syntax Diagrams</a></b></li>
<li><b><a href="vtablist.html">List Of Virtual Tables</a></b></li>
<li><a href="loadext.html">Loadable Extensions — Run Time</a></li>
<li><b><a href="locrsf.html">LoC Recommended Storage Format</a></b></li>
<li><a href="lockingv3.html">Locking And Concurrency In SQLite Version 3 — File</a></li>
<li><a href="errlog.html">Log — The Error And Warning</a></li>
<li><a href="wal.html">Logging — Write Ahead</a></li>
<li><b><a href="lts.html">Long Term Support</a></b></li>
<li><b><a href="privatebranch.html">Maintaining Private Branches Of SQLite</a></b></li>
<li><a href="qmplan.html">Management — Quality</a></li>
<li><b><a href="np1queryprob.html">Many Small Queries Are Efficient In SQLite</a></b></li>
<li><a href="sitemap.html">Map — SQLite Site</a></li>
<li><a href="mmap.html">Mapped I/O — Memory</a></li>
<li><a href="lang_mathfunc.html">Mathematical SQL Functions — Built In</a></li>
<li><b><a href="cpu.html">Measuring and Reducing CPU Usage in SQLite</a></b></li>
<li><a href="vtab.html">Mechanism Of SQLite — The Virtual Table</a></li>
<li><a href="malloc.html">Memory Allocation In SQLite — Dynamic</a></li>
<li><a href="inmemorydb.html">Memory Databases — In</a></li>
<li><b><a href="mmap.html">Memory Mapped I/O</a></b></li>
<li><a href="quickstart.html">Minutes Or Less — SQLite In 5</a></li>
<li><a href="sharedcache.html">Mode — SQLite Shared Cache</a></li>
<li><a href="walformat.html">mode File Format — WAL</a></li>
<li><a href="geopoly.html">Module — The Geopoly Interface To The SQLite R*Tree</a></li>
<li><a href="rtree.html">Module — The SQLite R*Tree</a></li>
<li><a href="zipfile.html">Module — The SQLite Zipfile</a></li>
<li><a href="session.html">Module C/C++ Interface — SQLite Session</a></li>
<li><a href="asyncvfs.html">Module For SQLite — An Asynchronous I/O</a></li>
<li><b><a href="mostdeployed.html">Most Widely Deployed SQL Database Engine</a></b></li>
<li><a href="threadsafe.html">Multi Threaded Applications — Using SQLite In</a></li>
<li><a href="lang_naming.html">Name Resolution — Database Object</a></li>
<li><a href="useovernet.html">Network, Caveats and Considerations — SQLite Over a</a></li>
<li><a href="news.html">News — Recent SQLite</a></li>
<li><a href="oldnews.html">News — SQLite Older</a></li>
<li><a href="queryplanner-ng.html">Next Generation Query Planner — The</a></li>
<li><a href="omitted.html">Not Implement — SQL Features That SQLite Does</a></li>
<li><a href="whynotgit.html">Not Use Git — Why SQLite Does</a></li>
<li><a href="unlock_notify.html">Notify API — SQLite Unlock</a></li>
<li><b><a href="nulinstr.html">NUL Characters In Strings</a></b></li>
<li><b><a href="nulls.html">NULL Handling in SQLite</a></b></li>
<li><a href="floatingpoint.html">Numbers — Floating Point</a></li>
<li><a href="versionnumbers.html">Numbers in SQLite — Version</a></li>
<li><a href="lang_naming.html">Object Name Resolution — Database</a></li>
<li><a href="oldnews.html">Older News — SQLite</a></li>
<li><b><a href="fileformat2.html">On Disk Format</a></b></li>
<li><a href="affcase1.html">OpenDocument Used SQLite? — What If</a></li>
<li><a href="json1.html">Operators — JSON Functions And</a></li>
<li><a href="withoutrowid.html">Optimization — Clustered Indexes and the WITHOUT ROWID</a></li>
<li><a href="optoverview.html">Optimizer Overview — The SQLite Query</a></li>
<li><a href="compile.html">Options — Compile time</a></li>
<li><a href="support.html">Options — SQLite Support</a></li>
<li><a href="useovernet.html">Over a Network, Caveats and Considerations — SQLite</a></li>
<li><a href="version3.html">Overview — SQLite Version 3</a></li>
<li><a href="optoverview.html">Overview — The SQLite Query Optimizer</a></li>
<li><a href="psow.html">Overwrite — Powersafe</a></li>
<li><a href="download.html">Page — SQLite Download</a></li>
<li><a href="index.html">Page — SQLite Home</a></li>
<li><a href="pgszchng2016.html">Page Size in SQLite Version 3.12.0 — Change in Default</a></li>
<li><a href="lemon.html">Parser Generator — The Lemon LALR(1)</a></li>
<li><b><a href="partialindex.html">Partial Indexes</a></b></li>
<li><a href="bindptr.html">Passing Interfaces — Pointer</a></li>
<li><a href="eqp.html">PLAN — EXPLAIN QUERY</a></li>
<li><a href="queryplanner-ng.html">Planner — The Next Generation Query</a></li>
<li><a href="queryplanner.html">Planning — Query</a></li>
<li><a href="floatingpoint.html">Point Numbers — Floating</a></li>
<li><b><a href="bindptr.html">Pointer Passing Interfaces</a></b></li>
<li><a href="invalidutf.html">Policy — Invalid UTF</a></li>
<li><b><a href="psow.html">Powersafe Overwrite</a></b></li>
<li><b><a href="pragma.html">Pragma statements supported by SQLite</a></b></li>
<li><a href="printf.html">printf() — SQLite's Built in</a></li>
<li><a href="privatebranch.html">Private Branches Of SQLite — Maintaining</a></li>
<li><a href="prosupport.html">Pro Support — SQLite</a></li>
<li><b><a href="profile.html">Profiling SQL Queries</a></b></li>
<li><a href="dbhash.html">Program — The dbhash.exe Utility</a></li>
<li><a href="sqlanalyze.html">Program — The sqlite3_analyzer.exe Utility</a></li>
<li><b><a href="qmplan.html">Quality Management</a></b></li>
<li><a href="profile.html">Queries — Profiling SQL</a></li>
<li><a href="np1queryprob.html">Queries Are Efficient In SQLite — Many Small</a></li>
<li><b><a href="lang.html">Query Language Understood by SQLite</a></b></li>
<li><a href="optoverview.html">Query Optimizer Overview — The SQLite</a></li>
<li><a href="eqp.html">QUERY PLAN — EXPLAIN</a></li>
<li><a href="queryplanner-ng.html">Query Planner — The Next Generation</a></li>
<li><b><a href="queryplanner.html">Query Planning</a></b></li>
<li><a href="faq.html">Questions — SQLite Frequently Asked</a></li>
<li><b><a href="quirks.html">Quirks, Caveats, and Gotchas In SQLite</a></b></li>
<li><a href="geopoly.html">R*Tree Module — The Geopoly Interface To The SQLite</a></li>
<li><a href="rtree.html">R*Tree Module — The SQLite</a></li>
<li><a href="rbu.html">RBU Extension — The</a></li>
<li><b><a href="news.html">Recent SQLite News</a></b></li>
<li><a href="locrsf.html">Recommended Storage Format — LoC</a></li>
<li><b><a href="recovery.html">Recovering Data From A Corrupt SQLite Database</a></b></li>
<li><a href="cpu.html">Reducing CPU Usage in SQLite — Measuring and</a></li>
<li><a href="capi3ref.html">Reference — C/C++ API</a></li>
<li><b><a href="lang_reindex.html">REINDEX</a></b></li>
<li><b><a href="changes.html">Release History Of SQLite</a></b></li>
<li><a href="chronology.html">Releases — History Of SQLite</a></li>
<li><a href="hirely.html">Reliability — High</a></li>
<li><b><a href="lang_replace.html">REPLACE</a></b></li>
<li><a href="hp1.html">Required — Javascript</a></li>
<li><a href="requirements.html">Requirements — SQLite</a></li>
<li><a href="lang_naming.html">Resolution — Database Object Name</a></li>
<li><a href="conflict.html">Resolution in SQLite — Constraint Conflict</a></li>
<li><a href="uri.html">Resource Identifiers — Uniform</a></li>
<li><b><a href="rescode.html">Result and Error Codes</a></b></li>
<li><b><a href="lang_returning.html">RETURNING</a></b></li>
<li><b><a href="rowvalue.html">Row Values</a></b></li>
<li><a href="withoutrowid.html">ROWID Optimization — Clustered Indexes and the WITHOUT</a></li>
<li><b><a href="rowidtable.html">Rowid Tables</a></b></li>
<li><b><a href="loadext.html">Run Time Loadable Extensions</a></b></li>
<li><b><a href="lang_savepoint.html">Savepoints</a></b></li>
<li><a href="lang_corefunc.html">Scalar SQL Functions — Built In</a></li>
<li><a href="schematab.html">Schema Table — The</a></li>
<li><b><a href="lang_select.html">SELECT</a></b></li>
<li><a href="selfcontained.html">Self Contained System — SQLite is a</a></li>
<li><a href="uintcseq.html">Sequence — The UINT Collating</a></li>
<li><a href="serverless.html">Serverless — SQLite Is</a></li>
<li><a href="sessionintro.html">Session Extension — The</a></li>
<li><a href="session.html">Session Module C/C++ Interface — SQLite</a></li>
<li><a href="sharedcache.html">Shared Cache Mode — SQLite</a></li>
<li><a href="cli.html">Shell For SQLite — Command Line</a></li>
<li><a href="cksumvfs.html">Shim — The Checksum VFS</a></li>
<li><a href="onefile.html">Single File Database — SQLite:</a></li>
<li><a href="sitemap.html">Site Map — SQLite</a></li>
<li><a href="pgszchng2016.html">Size in SQLite Version 3.12.0 — Change in Default Page</a></li>
<li><a href="np1queryprob.html">Small Queries Are Efficient In SQLite — Many</a></li>
<li><a href="getthecode.html">Source Code — How To Download Canonical SQLite</a></li>
<li><a href="speed.html">Speed Comparison — SQLite Database</a></li>
<li><a href="spellfix1.html">Spellfix1 Virtual Table — The</a></li>
<li><a href="fullsql.html">SQL — Full Featured</a></li>
<li><b><a href="lang_comment.html">SQL Comment Syntax</a></b></li>
<li><a href="mostdeployed.html">SQL Database Engine — Most Widely Deployed</a></li>
<li><b><a href="omitted.html">SQL Features That SQLite Does Not Implement</a></b></li>
<li><a href="appfunc.html">SQL Functions — Application Defined</a></li>
<li><a href="lang_mathfunc.html">SQL Functions — Built In Mathematical</a></li>
<li><a href="lang_corefunc.html">SQL Functions — Built In Scalar</a></li>
<li><a href="deterministic.html">SQL Functions — Deterministic</a></li>
<li><b><a href="lang_expr.html">SQL Language Expressions</a></b></li>
<li><a href="profile.html">SQL Queries — Profiling</a></li>
<li><b><a href="sqldiff.html">sqldiff.exe: Database Difference Utility</a></b></li>
<li><b><a href="sqlar.html">SQLite Archive Files</a></b></li>
<li><b><a href="https://sqlite.org/sqlar/">SQLite Archiver (sqlar.exe)</a></b></li>
<li><b><a href="appfileformat.html">SQLite As An Application File Format</a></b></li>
<li><b><a href="autoinc.html">SQLite Autoincrement</a></b></li>
<li><b><a href="backup.html">SQLite Backup API</a></b></li>
<li><b><a href="34to35.html">SQLite Changes From Version 3.4.2 To 3.5.0</a></b></li>
<li><b><a href="35to36.html">SQLite Changes From Version 3.5.9 To 3.6.0</a></b></li>
<li><b><a href="consortium.html">SQLite Consortium</a></b></li>
<li><b><a href="copyright.html">SQLite Copyright</a></b></li>
<li><b><a href="speed.html">SQLite Database Speed Comparison</a></b></li>
<li><b><a href="crew.html">SQLite Developers</a></b></li>
<li><b><a href="docs.html">SQLite Documentation</a></b></li>
<li><b><a href="download.html">SQLite Download Page</a></b></li>
<li><b><a href="foreignkeys.html">SQLite Foreign Key Support</a></b></li>
<li><b><a href="faq.html">SQLite Frequently Asked Questions</a></b></li>
<li><b><a href="fts3.html">SQLite FTS3 and FTS4 Extensions</a></b></li>
<li><b><a href="fts5.html">SQLite FTS5 Extension</a></b></li>
<li><b><a href="index.html">SQLite Home Page</a></b></li>
<li><b><a href="quickstart.html">SQLite In 5 Minutes Or Less</a></b></li>
<li><b><a href="selfcontained.html">SQLite is a Self Contained System</a></b></li>
<li><b><a href="serverless.html">SQLite Is Serverless</a></b></li>
<li><b><a href="transactional.html">SQLite Is Transactional</a></b></li>
<li><b><a href="lang_keywords.html">SQLite Keywords</a></b></li>
<li><b><a href="footprint.html">SQLite Library Footprint</a></b></li>
<li><b><a href="oldnews.html">SQLite Older News</a></b></li>
<li><b><a href="useovernet.html">SQLite Over a Network, Caveats and Considerations</a></b></li>
<li><b><a href="prosupport.html">SQLite Pro Support</a></b></li>
<li><b><a href="requirements.html">SQLite Requirements</a></b></li>
<li><b><a href="session.html">SQLite Session Module C/C++ Interface</a></b></li>
<li><b><a href="sharedcache.html">SQLite Shared Cache Mode</a></b></li>
<li><b><a href="sitemap.html">SQLite Site Map</a></b></li>
<li><b><a href="support.html">SQLite Support Options</a></b></li>
<li><b><a href="unlock_notify.html">SQLite Unlock Notify API</a></b></li>
<li><b><a href="version3.html">SQLite Version 3 Overview</a></b></li>
<li><b><a href="printf.html">SQLite's Built in printf()</a></b></li>
<li><a href="sqlanalyze.html">sqlite3_analyzer.exe Utility Program — The</a></li>
<li><b><a href="onefile.html">SQLite: Single File Database</a></b></li>
<li><a href="affcase1.html">SQLite? — What If OpenDocument Used</a></li>
<li><a href="dbpage.html">SQLITE_DBPAGE Virtual Table — The</a></li>
<li><a href="memstat.html">SQLITE_MEMSTAT Virtual Table — The</a></li>
<li><a href="stmt.html">SQLITE_STMT Virtual Table — The</a></li>
<li><a href="pragma.html">statements supported by SQLite — Pragma</a></li>
<li><a href="locrsf.html">Storage Format — LoC Recommended</a></li>
<li><b><a href="stricttables.html">STRICT Tables</a></b></li>
<li><a href="nulinstr.html">Strings — NUL Characters In</a></li>
<li><a href="lts.html">Support — Long Term</a></li>
<li><a href="foreignkeys.html">Support — SQLite Foreign Key</a></li>
<li><a href="prosupport.html">Support — SQLite Pro</a></li>
<li><a href="support.html">Support Options — SQLite</a></li>
<li><a href="pragma.html">supported by SQLite — Pragma statements</a></li>
<li><b><a href="swarmvtab.html">Swarmvtab Virtual Table</a></b></li>
<li><a href="lang_comment.html">Syntax — SQL Comment</a></li>
<li><a href="syntax.html">Syntax Diagrams — List of SQLite</a></li>
<li><b><a href="syntaxdiagrams.html">Syntax Diagrams For SQLite</a></b></li>
<li><a href="selfcontained.html">System — SQLite is a Self Contained</a></li>
<li><a href="https://www.fossil-scm.org/">System — The Fossil Version Control</a></li>
<li><b><a href="https://system.data.sqlite.org/">System.Data.SQLite</a></b></li>
<li><a href="lang_altertable.html">TABLE — ALTER</a></li>
<li><a href="lang_createtable.html">TABLE — CREATE</a></li>
<li><a href="lang_createvtab.html">TABLE — CREATE VIRTUAL</a></li>
<li><a href="lang_droptable.html">TABLE — DROP</a></li>
<li><a href="swarmvtab.html">Table — Swarmvtab Virtual</a></li>
<li><a href="csv.html">Table — The CSV Virtual</a></li>
<li><a href="dbstat.html">Table — The DBSTAT Virtual</a></li>
<li><a href="schematab.html">Table — The Schema</a></li>
<li><a href="spellfix1.html">Table — The Spellfix1 Virtual</a></li>
<li><a href="dbpage.html">Table — The SQLITE_DBPAGE Virtual</a></li>
<li><a href="memstat.html">Table — The SQLITE_MEMSTAT Virtual</a></li>
<li><a href="stmt.html">Table — The SQLITE_STMT Virtual</a></li>
<li><a href="unionvtab.html">Table — The UNION Virtual</a></li>
<li><a href="vtab.html">Table Mechanism Of SQLite — The Virtual</a></li>
<li><a href="carray.html">Table Valued Function — The Carray()</a></li>
<li><a href="completion.html">Table Valued Function — The COMPLETION()</a></li>
<li><a href="series.html">Table Valued Function — The generate_series</a></li>
<li><a href="bytecodevtab.html">Table Valued Functions — The Bytecode() And Tables_Used()</a></li>
<li><a href="imposter.html">Tables — Imposter</a></li>
<li><a href="vtablist.html">Tables — List Of Virtual</a></li>
<li><a href="rowidtable.html">Tables — Rowid</a></li>
<li><a href="stricttables.html">Tables — STRICT</a></li>
<li><a href="bytecodevtab.html">Tables_Used() Table Valued Functions — The Bytecode() And</a></li>
<li><a href="tclsqlite.html">Tcl interface to the SQLite library — The</a></li>
<li><b><a href="tempfiles.html">Temporary Files Used By SQLite</a></b></li>
<li><a href="lts.html">Term Support — Long</a></li>
<li><a href="testing.html">Tested — How SQLite Is</a></li>
<li><b><a href="th3.html">TH3</a></b></li>
<li><a href="fasterthanfs.html">Than The Filesystem — 35% Faster</a></li>
<li><a href="omitted.html">That SQLite Does Not Implement — SQL Features</a></li>
<li><b><a href="flextypegood.html">The Advantages Of Flexible Typing</a></b></li>
<li><b><a href="bytecodevtab.html">The Bytecode() And Tables_Used() Table Valued Functions</a></b></li>
<li><b><a href="c_interface.html">The C language interface to SQLite Version 2</a></b></li>
<li><b><a href="carray.html">The Carray() Table Valued Function</a></b></li>
<li><b><a href="cksumvfs.html">The Checksum VFS Shim</a></b></li>
<li><b><a href="completion.html">The COMPLETION() Table Valued Function</a></b></li>
<li><b><a href="csv.html">The CSV Virtual Table</a></b></li>
<li><b><a href="dbhash.html">The dbhash.exe Utility Program</a></b></li>
<li><b><a href="dbstat.html">The DBSTAT Virtual Table</a></b></li>
<li><b><a href="errlog.html">The Error And Warning Log</a></b></li>
<li><b><a href="https://www.fossil-scm.org/">The Fossil Version Control System</a></b></li>
<li><b><a href="series.html">The generate_series Table Valued Function</a></b></li>
<li><b><a href="geopoly.html">The Geopoly Interface To The SQLite R*Tree Module</a></b></li>
<li><b><a href="lang_indexedby.html">The INDEXED BY Clause</a></b></li>
<li><b><a href="lemon.html">The Lemon LALR(1) Parser Generator</a></b></li>
<li><b><a href="queryplanner-ng.html">The Next Generation Query Planner</a></b></li>
<li><b><a href="lang_conflict.html">The ON CONFLICT Clause</a></b></li>
<li><b><a href="rbu.html">The RBU Extension</a></b></li>
<li><b><a href="schematab.html">The Schema Table</a></b></li>
<li><b><a href="sessionintro.html">The Session Extension</a></b></li>
<li><b><a href="spellfix1.html">The Spellfix1 Virtual Table</a></b></li>
<li><b><a href="amalgamation.html">The SQLite Amalgamation</a></b></li>
<li><b><a href="opcode.html">The SQLite Bytecode Engine</a></b></li>
<li><b><a href="vfs.html">The SQLite OS Interface or "VFS"</a></b></li>
<li><b><a href="optoverview.html">The SQLite Query Optimizer Overview</a></b></li>
<li><b><a href="rtree.html">The SQLite R*Tree Module</a></b></li>
<li><b><a href="zipfile.html">The SQLite Zipfile Module</a></b></li>
<li><b><a href="sqlanalyze.html">The sqlite3_analyzer.exe Utility Program</a></b></li>
<li><b><a href="dbpage.html">The SQLITE_DBPAGE Virtual Table</a></b></li>
<li><b><a href="memstat.html">The SQLITE_MEMSTAT Virtual Table</a></b></li>
<li><b><a href="stmt.html">The SQLITE_STMT Virtual Table</a></b></li>
<li><b><a href="tclsqlite.html">The Tcl interface to the SQLite library</a></b></li>
<li><b><a href="uintcseq.html">The UINT Collating Sequence</a></b></li>
<li><b><a href="unionvtab.html">The UNION Virtual Table</a></b></li>
<li><b><a href="assert.html">The Use Of assert() In SQLite</a></b></li>
<li><b><a href="vdbe.html">The Virtual Database Engine of SQLite</a></b></li>
<li><b><a href="vtab.html">The Virtual Table Mechanism Of SQLite</a></b></li>
<li><b><a href="lang_with.html">The WITH Clause</a></b></li>
<li><a href="threadsafe.html">Threaded Applications — Using SQLite In Multi</a></li>
<li><a href="lang_datefunc.html">Time Functions — Date And</a></li>
<li><a href="loadext.html">Time Loadable Extensions — Run</a></li>
<li><a href="compile.html">time Options — Compile</a></li>
<li><b><a href="lang_transaction.html">Transaction</a></b></li>
<li><a href="transactional.html">Transactional — SQLite Is</a></li>
<li><a href="lang_createtrigger.html">TRIGGER — CREATE</a></li>
<li><a href="lang_droptrigger.html">TRIGGER — DROP</a></li>
<li><a href="flextypegood.html">Typing — The Advantages Of Flexible</a></li>
<li><a href="uintcseq.html">UINT Collating Sequence — The</a></li>
<li><a href="lang.html">Understood by SQLite — Query Language</a></li>
<li><a href="undoredo.html">Undo/Redo With SQLite — Automatic</a></li>
<li><b><a href="uri.html">Uniform Resource Identifiers</a></b></li>
<li><a href="unionvtab.html">UNION Virtual Table — The</a></li>
<li><a href="unlock_notify.html">Unlock Notify API — SQLite</a></li>
<li><b><a href="lang_update.html">UPDATE</a></b></li>
<li><b><a href="lang_upsert.html">UPSERT</a></b></li>
<li><a href="cpu.html">Usage in SQLite — Measuring and Reducing CPU</a></li>
<li><a href="whynotgit.html">Use Git — Why SQLite Does Not</a></li>
<li><a href="assert.html">Use Of assert() In SQLite — The</a></li>
<li><a href="tempfiles.html">Used By SQLite — Temporary Files</a></li>
<li><a href="affcase1.html">Used SQLite? — What If OpenDocument</a></li>
<li><a href="famous.html">Users Of SQLite — Well Known</a></li>
<li><a href="whentouse.html">Uses For SQLite — Appropriate</a></li>
<li><b><a href="threadsafe.html">Using SQLite In Multi Threaded Applications</a></b></li>
<li><a href="invalidutf.html">UTF Policy — Invalid</a></li>
<li><a href="sqldiff.html">Utility — sqldiff.exe: Database Difference</a></li>
<li><a href="dbhash.html">Utility Program — The dbhash.exe</a></li>
<li><a href="sqlanalyze.html">Utility Program — The sqlite3_analyzer.exe</a></li>
<li><b><a href="lang_vacuum.html">VACUUM</a></b></li>
<li><a href="carray.html">Valued Function — The Carray() Table</a></li>
<li><a href="completion.html">Valued Function — The COMPLETION() Table</a></li>
<li><a href="series.html">Valued Function — The generate_series Table</a></li>
<li><a href="bytecodevtab.html">Valued Functions — The Bytecode() And Tables_Used() Table</a></li>
<li><a href="rowvalue.html">Values — Row</a></li>
<li><a href="datatypes.html">version 2 — Datatypes In SQLite</a></li>
<li><a href="c_interface.html">Version 2 — The C language interface to SQLite</a></li>
<li><a href="capi3ref.html">Version 3 — C/C++ Interface For SQLite</a></li>
<li><a href="lockingv3.html">Version 3 — File Locking And Concurrency In SQLite</a></li>
<li><a href="capi3.html">Version 3 (old) — C/C++ Interface For SQLite</a></li>
<li><a href="version3.html">Version 3 Overview — SQLite</a></li>
<li><a href="pgszchng2016.html">Version 3.12.0 — Change in Default Page Size in SQLite</a></li>
<li><a href="34to35.html">Version 3.4.2 To 3.5.0 — SQLite Changes From</a></li>
<li><a href="35to36.html">Version 3.5.9 To 3.6.0 — SQLite Changes From</a></li>
<li><a href="https://www.fossil-scm.org/">Version Control System — The Fossil</a></li>
<li><b><a href="versionnumbers.html">Version Numbers in SQLite</a></b></li>
<li><a href="intern-v-extern-blob.html">Versus External BLOBs — Internal</a></li>
<li><a href="vfs.html">VFS — The SQLite OS Interface or</a></li>
<li><a href="cksumvfs.html">VFS Shim — The Checksum</a></li>
<li><a href="lang_createview.html">VIEW — CREATE</a></li>
<li><a href="lang_dropview.html">VIEW — DROP</a></li>
<li><a href="vdbe.html">Virtual Database Engine of SQLite — The</a></li>
<li><a href="lang_createvtab.html">VIRTUAL TABLE — CREATE</a></li>
<li><a href="swarmvtab.html">Virtual Table — Swarmvtab</a></li>
<li><a href="csv.html">Virtual Table — The CSV</a></li>
<li><a href="dbstat.html">Virtual Table — The DBSTAT</a></li>
<li><a href="spellfix1.html">Virtual Table — The Spellfix1</a></li>
<li><a href="dbpage.html">Virtual Table — The SQLITE_DBPAGE</a></li>
<li><a href="memstat.html">Virtual Table — The SQLITE_MEMSTAT</a></li>
<li><a href="stmt.html">Virtual Table — The SQLITE_STMT</a></li>
<li><a href="unionvtab.html">Virtual Table — The UNION</a></li>
<li><a href="vtab.html">Virtual Table Mechanism Of SQLite — The</a></li>
<li><a href="vtablist.html">Virtual Tables — List Of</a></li>
<li><b><a href="cves.html">Vulnerabilities</a></b></li>
<li><b><a href="walformat.html">WAL mode File Format</a></b></li>
<li><a href="errlog.html">Warning Log — The Error And</a></li>
<li><b><a href="keyword_index.html">Website Keyword Index</a></b></li>
<li><b><a href="famous.html">Well Known Users Of SQLite</a></b></li>
<li><b><a href="affcase1.html">What If OpenDocument Used SQLite?</a></b></li>
<li><b><a href="whyc.html">Why Is SQLite Coded In C</a></b></li>
<li><b><a href="whynotgit.html">Why SQLite Does Not Use Git</a></b></li>
<li><a href="mostdeployed.html">Widely Deployed SQL Database Engine — Most</a></li>
<li><b><a href="windowfunctions.html">Window Functions</a></b></li>
<li><a href="lang_with.html">WITH Clause — The</a></li>
<li><a href="undoredo.html">With SQLite — Automatic Undo/Redo</a></li>
<li><a href="withoutrowid.html">WITHOUT ROWID Optimization — Clustered Indexes and the</a></li>
<li><a href="queryplanner.html">Work — How Indexes</a></li>
<li><a href="howitworks.html">Works — How SQLite</a></li>
<li><b><a href="wal.html">Write Ahead Logging</a></b></li>
<li><b><a href="zeroconf.html">Zero Configuration</a></b></li>
<li><a href="zipfile.html">Zipfile Module — The SQLite</a></li>
</ul>
|
