1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
3
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
4
<title>SQLite Site Map</title>
5
<style type="text/css">
8
font-family: Verdana, sans-serif;
13
a:visited { color: #734559 }
15
.logo { position:absolute; margin:3px; }
31
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
32
.toolbar a:visited { color: white; }
33
.toolbar a:hover { color: #044a64; background: white; }
35
.content { margin: 5%; }
36
.content dt { font-weight:bold; }
37
.content dd { margin-bottom: 25px; margin-left:20%; }
38
.content ul { padding:0px; padding-left: 15px; margin:0px; }
41
.se { background: url(images/se.gif) 100% 100% no-repeat #044a64}
42
.sw { background: url(images/sw.gif) 0% 100% no-repeat }
43
.ne { background: url(images/ne.gif) 100% 0% no-repeat }
44
.nw { background: url(images/nw.gif) 0% 0% no-repeat }
46
/* Things for "fancyformat" documents start here. */
47
.fancy img+p {font-style:italic}
48
.fancy .codeblock i { color: darkblue; }
49
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
50
.fancy h2 { margin-left: 10px }
51
.fancy h3 { margin-left: 20px }
52
.fancy h4 { margin-left: 30px }
53
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
54
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
55
.fancy #toc a { color: darkblue ; text-decoration: none }
56
.fancy .todo { color: #AA3333 ; font-style : italic }
57
.fancy .todo:before { content: 'TODO:' }
58
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
59
.fancy img { display:block; }
60
.fancy :link:hover, .fancy :visited:hover { background: wheat }
61
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
62
.fancy li p { margin: 1em 0 }
63
/* End of "fancyformat" specific rules. */
69
<div><!-- container div to satisfy validator -->
72
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
74
<div><!-- IE hack to prevent disappearing logo--></div>
75
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
77
<table width=100% style="clear:both"><tr><td>
78
<div class="se"><div class="sw"><div class="ne"><div class="nw">
79
<table width=100% style="padding:0;margin:0;cell-spacing:0"><tr>
82
<a href="about.html">About</a>
83
<a href="sitemap.html">Sitemap</a>
84
<a href="docs.html">Documentation</a>
85
<a href="download.html">Download</a>
86
<a href="copyright.html">License</a>
87
<a href="news.html">News</a>
88
<a href="support.html">Support</a>
91
gMsg = "Search SQLite Docs..."
92
function entersearch() {
93
var q = document.getElementById("q");
94
if( q.value == gMsg ) { q.value = "" }
95
q.style.color = "black"
96
q.style.fontStyle = "normal"
98
function leavesearch() {
99
var q = document.getElementById("q");
100
if( q.value == "" ) {
102
q.style.color = "#044a64"
103
q.style.fontStyle = "italic"
108
<div style="padding:0 1em 0px 0;white-space:nowrap">
109
<form name=f method="GET" action="http://www.sqlite.org/search">
110
<input id=q name=q type=text
111
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
112
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
116
</div></div></div></div>
118
<div class=startsearch></div>
122
<h2>Popular Pages:</h2>
124
<table border=0 width="100%">
125
<tr><td valign=top><ul>
126
<li> <a href="features.html">Features</a> </li>
127
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
128
<li> <a href="famous.html">Well-known Users</a> </li>
129
<li> <a href="quickstart.html">Getting Started</a> </li>
130
<li> <a href="whentouse.html">When To Use SQLite</a> </li>
131
<li> <a href="different.html">Distinctive Features</a> </li>
132
<li> <a href="doclist.html">Alphabetical list of docs</a> </li>
133
<li> <a href="books.html">Books About SQLite</a> </li>
134
<li> <a href="keyword_index.html">Website Keyword Index</a> </li>
135
</ul><td valign=top><ul>
136
<li> <a href="lang.html">SQL Syntax</a>
138
<li> <a href="pragma.html#toc">Pragmas</a>
139
<li> <a href="lang_corefunc.html">SQL functions</a>
140
<li> <a href="lang_datefunc.html">Date & time functions</a>
141
<li> <a href="lang_aggfunc.html">Aggregate functions</a>
143
<li> <a href="c3ref/intro.html">C/C++ Interface Spec</a>
145
<li> <a href="cintro.html">Introduction</a>
146
<li> <a href="c3ref/funclist.html">List of C-language APIs</a>
149
<li> <a href="tclsqlite.html">The TCL Interface Spec</a>
150
</ul><td valign=top><ul>
151
<li> <a href="support.html#mailinglists">Mailing Lists</a> </li>
152
<li> <a href="http://www.sqlite.org/src/wiki?name=Bug+Reports">Report a Bug</a> </li>
153
<li> <a href="download.html#cvs">Version control</a>
155
<li> <a href="http://www.sqlite.org/src">Source code timeline</a> </li>
156
<li> <a href="http://www.sqlite.org/docsrc">Documentation timeline</a> </li>
161
<a name="pindex"></a>
164
<small><a href="http://en.wikipedia.org/wiki/Key_Word_in_Context">(what is
165
this?)</a></small></h2>
167
<table align=right border=1 cellpadding=10>
168
<tr><td>Other Documentation Indices:
170
<li><a href="docs.html">Categorical Document List</a>
171
<li><a href="books.html">Books About SQLite</a>
172
<li><a href="doclist.html">Alphabetical List Of Documents</a>
173
<li><a href="keyword_index.html">Website Keyword Index</a>
178
<li><a href="shortnames.html">8+3 Filenames</a></li><li><a href="about.html">About SQLite</a></li><li><a href="books.html">About SQLite — Books</a></li><li><a href="malloc.html">Allocation In SQLite — Dynamic Memory</a></li><li><a href="doclist.html">Alphabetical List Of SQLite Documents</a></li><li><a href="amalgamation.html">Amalgamation — The SQLite</a></li><li><a href="asyncvfs.html">An Asynchronous I/O Module For SQLite</a></li><li><a href="cintro.html">An Introduction To The SQLite C/C++ Interface</a></li><li><a href="lockingv3.html">And Concurrency In SQLite Version 3 — File Locking</a></li><li><a href="fts3.html">and FTS4 Extensions — SQLite FTS3</a></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="threadsafe.html">Applications — Using SQLite In Multi-Threaded</a></li><li><a href="whentouse.html">Appropriate Uses For SQLite</a></li><li><a href="arch.html">Architecture of SQLite</a></li><li><a href="faq.html">Asked Questions — SQLite Frequently</a></li><li><a href="asyncvfs.html">Asynchronous I/O Module For SQLite — An</a></li><li><a href="atomiccommit.html">Atomic Commit In SQLite</a></li><li><a href="autoinc.html">Autoincrement — SQLite</a></li><li><a href="vfs.html">Backend (VFS) To SQLite — The OS</a></li><li><a href="backup.html">Backup API — SQLite</a></li><li><a href="intern-v-extern-blob.html">BLOBs — Internal Versus External</a></li><li><a href="books.html">Books About SQLite</a></li><li><a href="privatebranch.html">Branches Of SQLite — Private</a></li><li><a href="custombuild.html">Builds Of SQLite — Custom</a></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><a href="capi3ref.html">C/C++ Interface For SQLite Version 3</a></li><li><a href="capi3.html">C/C++ Interface For SQLite Version 3 (old)</a></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="sqlite.html">Command Line Shell For SQLite</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="compile.html">Compilation Options For SQLite</a></li><li><a href="howtocompile.html">Compile SQLite — How To</a></li><li><a href="lockingv3.html">Concurrency In SQLite Version 3 — File Locking And</a></li><li><a href="conflict.html">Conflict Resolution in SQLite — Constraint</a></li><li><a href="consortium.html">Consortium — SQLite</a></li><li><a href="conflict.html">Constraint Conflict Resolution in SQLite</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="custombuild.html">Custom Builds Of SQLite</a></li><li><a href="onefile.html">Database — SQLite: Single File</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><a href="speed.html">Database Speed Comparison — SQLite</a></li><li><a href="fileformat2.html">Databases — File Format For SQLite</a></li><li><a href="inmemorydb.html">Databases — In-Memory</a></li><li><a href="datatypes.html">Datatypes In SQLite version 2</a></li><li><a href="datatype3.html">Datatypes In SQLite Version 3</a></li><li><a href="mostdeployed.html">Deployed SQL Database Engine — Most Widely</a></li><li><a href="dev.html">Developer Links — SQLite</a></li><li><a href="crew.html">Developers — SQLite</a></li><li><a href="syntaxdiagrams.html">Diagrams For SQLite — Syntax</a></li><li><a href="different.html">Distinctive Features Of SQLite</a></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="download.html">Download Page — SQLite</a></li><li><a href="malloc.html">Dynamic Memory Allocation In SQLite</a></li><li><a href="mostdeployed.html">Engine — Most Widely Deployed SQL Database</a></li><li><a href="vdbe.html">Engine of SQLite — The Virtual Database</a></li><li><a href="eqp.html">EXPLAIN QUERY PLAN</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="features.html">Features Of SQLite</a></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="formatchng.html">File Format Changes in SQLite</a></li><li><a href="fileformat2.html">File Format For SQLite Databases</a></li><li><a href="lockingv3.html">File Locking And Concurrency In SQLite Version 3</a></li><li><a href="shortnames.html">Filenames — 8+3</a></li><li><a href="tempfiles.html">Files Used By SQLite — Temporary</a></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="formatchng.html">Format Changes in SQLite — File</a></li><li><a href="fileformat2.html">Format For SQLite Databases — File</a></li><li><a href="faq.html">Frequently Asked Questions — SQLite</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="nulls.html">Handling in SQLite — NULL</a></li><li><a href="changes.html">History Of SQLite — Release</a></li><li><a href="index.html">Home Page — SQLite</a></li><li><a href="testing.html">How SQLite Is Tested</a></li><li><a href="howtocompile.html">How To Compile SQLite</a></li><li><a href="howtocorrupt.html">How To Corrupt An SQLite Database File</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><a href="limits.html">Implementation Limits For SQLite</a></li><li><a href="inmemorydb.html">In-Memory Databases</a></li><li><a href="keyword_index.html">Index — Website Keyword</a></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="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="intern-v-extern-blob.html">Internal Versus External BLOBs</a></li><li><a href="cintro.html">Introduction To The SQLite C/C++ Interface — An</a></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="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="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="sqlite.html">Line Shell For SQLite — Command</a></li><li><a href="dev.html">Links — SQLite Developer</a></li><li><a href="doclist.html">List Of SQLite Documents — Alphabetical</a></li><li><a href="lockingv3.html">Locking And Concurrency In SQLite Version 3 — File</a></li><li><a href="wal.html">Logging — Write-Ahead</a></li><li><a href="opcode.html">Machine Opcodes — SQLite Virtual</a></li><li><a href="sitemap.html">Map — SQLite Site</a></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="quickstart.html">Minutes Or Less — SQLite In 5</a></li><li><a href="sharedcache.html">Mode — SQLite Shared-Cache</a></li><li><a href="rtree.html">Module — The SQLite R*Tree</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><a href="mostdeployed.html">Most Widely Deployed SQL Database Engine</a></li><li><a href="threadsafe.html">Multi-Threaded Applications — Using SQLite In</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="omitted.html">Not Implement — SQL Features That SQLite Does</a></li><li><a href="nulls.html">NULL Handling in SQLite</a></li><li><a href="oldnews.html">Older News — SQLite</a></li><li><a href="opcode.html">Opcodes — SQLite Virtual Machine</a></li><li><a href="optoverview.html">Optimizer Overview — The SQLite Query</a></li><li><a href="support.html">Options — SQLite Support</a></li><li><a href="compile.html">Options For SQLite — Compilation</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="eqp.html">PLAN — EXPLAIN QUERY</a></li><li><a href="queryplanner.html">Planning — Query</a></li><li><a href="psow.html">Powersafe Overwrite</a></li><li><a href="pragma.html">Pragma statements supported by SQLite</a></li><li><a href="privatebranch.html">Private Branches Of SQLite</a></li><li><a href="lang.html">Query Language Understood by SQLite</a></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.html">Query Planning</a></li><li><a href="faq.html">Questions — SQLite Frequently Asked</a></li><li><a href="rtree.html">R*Tree Module — The SQLite</a></li><li><a href="news.html">Recent SQLite News</a></li><li><a href="changes.html">Release History Of SQLite</a></li><li><a href="requirements.html">Requirements — SQLite</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><a href="selfcontained.html">Self-Contained — SQLite Is</a></li><li><a href="serverless.html">Serverless — SQLite Is</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="sqlite.html">Shell For SQLite — Command Line</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="speed.html">Speed Comparison — SQLite Database</a></li><li><a href="mostdeployed.html">SQL Database Engine — Most Widely Deployed</a></li><li><a href="omitted.html">SQL Features That SQLite Does Not Implement</a></li><li><a href="autoinc.html">SQLite Autoincrement</a></li><li><a href="backup.html">SQLite Backup API</a></li><li><a href="34to35.html">SQLite Changes From Version 3.4.2 To 3.5.0</a></li><li><a href="35to36.html">SQLite Changes From Version 3.5.9 To 3.6.0</a></li><li><a href="consortium.html">SQLite Consortium</a></li><li><a href="copyright.html">SQLite Copyright</a></li><li><a href="speed.html">SQLite Database Speed Comparison</a></li><li><a href="dev.html">SQLite Developer Links</a></li><li><a href="crew.html">SQLite Developers</a></li><li><a href="docs.html">SQLite Documentation</a></li><li><a href="download.html">SQLite Download Page</a></li><li><a href="foreignkeys.html">SQLite Foreign Key Support</a></li><li><a href="faq.html">SQLite Frequently Asked Questions</a></li><li><a href="fts3.html">SQLite FTS3 and FTS4 Extensions</a></li><li><a href="index.html">SQLite Home Page</a></li><li><a href="quickstart.html">SQLite In 5 Minutes Or Less</a></li><li><a href="selfcontained.html">SQLite Is Self-Contained</a></li><li><a href="serverless.html">SQLite Is Serverless</a></li><li><a href="transactional.html">SQLite Is Transactional</a></li><li><a href="footprint.html">SQLite Library Footprint</a></li><li><a href="oldnews.html">SQLite Older News</a></li><li><a href="requirements.html">SQLite Requirements</a></li><li><a href="session.html">SQLite Session Module C/C++ Interface</a></li><li><a href="sharedcache.html">SQLite Shared-Cache Mode</a></li><li><a href="sitemap.html">SQLite Site Map</a></li><li><a href="support.html">SQLite Support Options</a></li><li><a href="th3.html">SQLite TH3</a></li><li><a href="unlock_notify.html">SQLite Unlock-Notify API</a></li><li><a href="version3.html">SQLite Version 3 Overview</a></li><li><a href="opcode.html">SQLite Virtual Machine Opcodes</a></li><li><a href="onefile.html">SQLite: Single File Database</a></li><li><a href="pragma.html">statements supported by SQLite — Pragma</a></li><li><a href="foreignkeys.html">Support — SQLite Foreign Key</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><a href="syntaxdiagrams.html">Syntax Diagrams For SQLite</a></li><li><a href="vtab.html">Table Mechanism Of SQLite — The Virtual</a></li><li><a href="tclsqlite.html">Tcl interface to the SQLite library — The</a></li><li><a href="tempfiles.html">Temporary Files Used By SQLite</a></li><li><a href="testing.html">Tested — How SQLite Is</a></li><li><a href="th3.html">TH3 — SQLite</a></li><li><a href="omitted.html">That SQLite Does Not Implement — SQL Features</a></li><li><a href="c_interface.html">The C language interface to SQLite Version 2</a></li><li><a href="vfs.html">The OS Backend (VFS) To SQLite</a></li><li><a href="amalgamation.html">The SQLite Amalgamation</a></li><li><a href="optoverview.html">The SQLite Query Optimizer Overview</a></li><li><a href="rtree.html">The SQLite R*Tree Module</a></li><li><a href="tclsqlite.html">The Tcl interface to the SQLite library</a></li><li><a href="vdbe.html">The Virtual Database Engine of SQLite</a></li><li><a href="vtab.html">The Virtual Table Mechanism Of SQLite</a></li><li><a href="transactional.html">Transactional — SQLite Is</a></li><li><a href="lang.html">Understood by SQLite — Query Language</a></li><li><a href="uri.html">Uniform Resource Identifiers</a></li><li><a href="unlock_notify.html">Unlock-Notify API — SQLite</a></li><li><a href="tempfiles.html">Used By SQLite — Temporary Files</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><a href="threadsafe.html">Using SQLite In Multi-Threaded Applications</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="datatype3.html">Version 3 — Datatypes In 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="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="intern-v-extern-blob.html">Versus External BLOBs — Internal</a></li><li><a href="vdbe.html">Virtual Database Engine of SQLite — The</a></li><li><a href="opcode.html">Virtual Machine Opcodes — SQLite</a></li><li><a href="vtab.html">Virtual Table Mechanism Of SQLite — The</a></li><li><a href="keyword_index.html">Website Keyword Index</a></li><li><a href="famous.html">Well-Known Users Of SQLite</a></li><li><a href="mostdeployed.html">Widely Deployed SQL Database Engine — Most</a></li><li><a href="wal.html">Write-Ahead Logging</a></li><li><a href="zeroconf.html">Zero-Configuration</a></li>