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
|
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Syntax Diagrams For SQLite</title>
<style type="text/css">
body {
margin: auto;
font-family: Verdana, sans-serif;
padding: 8px 1%;
}
a { color: #044a64 }
a:visited { color: #734559 }
.logo { position:absolute; margin:3px; }
.tagline {
float:right;
text-align:right;
font-style:italic;
width:300px;
margin:12px;
margin-top:58px;
}
.menubar {
clear: both;
border-radius: 8px;
background: #044a64;
padding: 0px;
margin: 0px;
cell-spacing: 0px;
}
.toolbar {
text-align: center;
line-height: 1.6em;
margin: 0;
padding: 0px 8px;
}
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
.toolbar a:visited { color: white; }
.toolbar a:hover { color: #044a64; 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; }
/* Things for "fancyformat" documents start here. */
.fancy img+p {font-style:italic}
.fancy .codeblock i { color: darkblue; }
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
.fancy h2 { margin-left: 10px }
.fancy h3 { margin-left: 20px }
.fancy h4 { margin-left: 30px }
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
.fancy #toc a { color: darkblue ; text-decoration: none }
.fancy .todo { color: #AA3333 ; font-style : italic }
.fancy .todo:before { content: 'TODO:' }
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
.fancy img { display:block; }
.fancy :link:hover, .fancy :visited:hover { background: wheat }
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
.fancy li p { margin: 1em 0 }
/* End of "fancyformat" specific rules. */
</style>
</head>
<body>
<div><!-- container div to satisfy validator -->
<a href="index.html">
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
border="0"></a>
<div><!-- IE hack to prevent disappearing logo--></div>
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
<table width=100% class="menubar"><tr>
<td width=100%>
<div class="toolbar">
<a href="about.html">About</a>
<a href="sitemap.html">Sitemap</a>
<a href="docs.html">Documentation</a>
<a href="download.html">Download</a>
<a href="copyright.html">License</a>
<a href="news.html">News</a>
<a href="support.html">Support</a>
</div>
<script>
gMsg = "Search SQLite Docs..."
function entersearch() {
var q = document.getElementById("q");
if( q.value == gMsg ) { q.value = "" }
q.style.color = "black"
q.style.fontStyle = "normal"
}
function leavesearch() {
var q = document.getElementById("q");
if( q.value == "" ) {
q.value = gMsg
q.style.color = "#044a64"
q.style.fontStyle = "italic"
}
}
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;
}
</script>
<td>
<div style="padding:0 1em 0px 0;white-space:nowrap">
<form name=f method="GET" action="http://www.sqlite.org/search">
<input id=q name=q type=text
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...">
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
</form>
</div>
</table>
<div class=startsearch></div>
<h1 align=center>Syntax Diagrams For SQLite</h1>
<h4>sql-stmt-list:</h4><blockquote>
<img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br>
References: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang.html">lang.html</a>
</blockquote>
<h4>sql-stmt:</h4><blockquote>
<img src="images/syntax/sql-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt-list">sql-stmt-list</a><br></br>
References: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#analyze-stmt">analyze-stmt</a> <a href="#attach-stmt">attach-stmt</a> <a href="#begin-stmt">begin-stmt</a> <a href="#commit-stmt">commit-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#create-virtual-table-stmt">create-virtual-table-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#detach-stmt">detach-stmt</a> <a href="#drop-index-stmt">drop-index-stmt</a> <a href="#drop-table-stmt">drop-table-stmt</a> <a href="#drop-trigger-stmt">drop-trigger-stmt</a> <a href="#drop-view-stmt">drop-view-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#pragma-stmt">pragma-stmt</a> <a href="#reindex-stmt">reindex-stmt</a> <a href="#release-stmt">release-stmt</a> <a href="#rollback-stmt">rollback-stmt</a> <a href="#savepoint-stmt">savepoint-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a> <a href="#vacuum-stmt">vacuum-stmt</a><br></br>
See also: <a href="lang.html">lang.html</a> <a href="lang_explain.html">lang_explain.html</a>
</blockquote>
<h4>alter-table-stmt:</h4><blockquote>
<img src="images/syntax/alter-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#column-def">column-def</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a>
</blockquote>
<h4>analyze-stmt:</h4><blockquote>
<img src="images/syntax/analyze-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_analyze.html">lang_analyze.html</a>
</blockquote>
<h4>attach-stmt:</h4><blockquote>
<img src="images/syntax/attach-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_attach.html">lang_attach.html</a>
</blockquote>
<h4>begin-stmt:</h4><blockquote>
<img src="images/syntax/begin-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<h4>commit-stmt:</h4><blockquote>
<img src="images/syntax/commit-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<h4>rollback-stmt:</h4><blockquote>
<img src="images/syntax/rollback-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a> <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<h4>savepoint-stmt:</h4><blockquote>
<img src="images/syntax/savepoint-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
</blockquote>
<h4>release-stmt:</h4><blockquote>
<img src="images/syntax/release-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
</blockquote>
<h4>create-index-stmt:</h4><blockquote>
<img src="images/syntax/create-index-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#indexed-column">indexed-column</a><br></br>
See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>indexed-column:</h4><blockquote>
<img src="images/syntax/indexed-column.gif"></img><br></br>
Used by: <a href="#create-index-stmt">create-index-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>create-table-stmt:</h4><blockquote>
<img src="images/syntax/create-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#column-def">column-def</a> <a href="#select-stmt">select-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_createtable.html">lang_createtable.html</a>
</blockquote>
<h4>column-def:</h4><blockquote>
<img src="images/syntax/column-def.gif"></img><br></br>
Used by: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#create-table-stmt">create-table-stmt</a><br></br>
References: <a href="#column-constraint">column-constraint</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<h4>type-name:</h4><blockquote>
<img src="images/syntax/type-name.gif"></img><br></br>
Used by: <a href="#column-def">column-def</a> <a href="#expr">expr</a><br></br>
References: <a href="#signed-number">signed-number</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>column-constraint:</h4><blockquote>
<img src="images/syntax/column-constraint.gif"></img><br></br>
Used by: <a href="#column-def">column-def</a><br></br>
References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#literal-value">literal-value</a> <a href="#signed-number">signed-number</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<h4>signed-number:</h4><blockquote>
<img src="images/syntax/signed-number.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#pragma-value">pragma-value</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<h4>table-constraint:</h4><blockquote>
<img src="images/syntax/table-constraint.gif"></img><br></br>
Used by: <a href="#create-table-stmt">create-table-stmt</a><br></br>
References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#indexed-column">indexed-column</a><br></br>
See also: <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#primkeyconst">lang_createtable.html#primkeyconst</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<h4>foreign-key-clause:</h4><blockquote>
<img src="images/syntax/foreign-key-clause.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a>
</blockquote>
<h4>conflict-clause:</h4><blockquote>
<img src="images/syntax/conflict-clause.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_conflict.html">lang_conflict.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a>
</blockquote>
<h4>create-trigger-stmt:</h4><blockquote>
<img src="images/syntax/create-trigger-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#delete-stmt">delete-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a>
</blockquote>
<h4>create-view-stmt:</h4><blockquote>
<img src="images/syntax/create-view-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_createview.html">lang_createview.html</a>
</blockquote>
<h4>create-virtual-table-stmt:</h4><blockquote>
<img src="images/syntax/create-virtual-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_createvtab.html">lang_createvtab.html</a>
</blockquote>
<h4>with-clause:</h4><blockquote>
<img src="images/syntax/with-clause.gif"></img><br></br>
Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#insert-stmt">insert-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#cte-table-name">cte-table-name</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a>
</blockquote>
<h4>cte-table-name:</h4><blockquote>
<img src="images/syntax/cte-table-name.gif"></img><br></br>
Used by: <a href="#recursive-cte">recursive-cte</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a>
</blockquote>
<h4>recursive-cte:</h4><blockquote>
<img src="images/syntax/recursive-cte.gif"></img><br></br><br></br>
References: <a href="#cte-table-name">cte-table-name</a><br></br>
See also: <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a>
</blockquote>
<h4>common-table-expression:</h4><blockquote>
<img src="images/syntax/common-table-expression.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br>
References: <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>delete-stmt:</h4><blockquote>
<img src="images/syntax/delete-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a>
</blockquote>
<h4>delete-stmt-limited:</h4><blockquote>
<img src="images/syntax/delete-stmt-limited.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_delete.html">lang_delete.html</a>
</blockquote>
<h4>detach-stmt:</h4><blockquote>
<img src="images/syntax/detach-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_detach.html">lang_detach.html</a>
</blockquote>
<h4>drop-index-stmt:</h4><blockquote>
<img src="images/syntax/drop-index-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_dropindex.html">lang_dropindex.html</a>
</blockquote>
<h4>drop-table-stmt:</h4><blockquote>
<img src="images/syntax/drop-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_droptable.html">lang_droptable.html</a>
</blockquote>
<h4>drop-trigger-stmt:</h4><blockquote>
<img src="images/syntax/drop-trigger-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_droptrigger.html">lang_droptrigger.html</a>
</blockquote>
<h4>drop-view-stmt:</h4><blockquote>
<img src="images/syntax/drop-view-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_dropview.html">lang_dropview.html</a>
</blockquote>
<h4>expr:</h4><blockquote>
<img src="images/syntax/expr.gif"></img><br></br>
Used by: <a href="#attach-stmt">attach-stmt</a> <a href="#column-constraint">column-constraint</a> <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#join-constraint">join-constraint</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#table-constraint">table-constraint</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#literal-value">literal-value</a> <a href="#raise-function">raise-function</a> <a href="#select-stmt">select-stmt</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>raise-function:</h4><blockquote>
<img src="images/syntax/raise-function.gif"></img><br></br>
Used by: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createtrigger.html#raise">lang_createtrigger.html#raise</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>literal-value:</h4><blockquote>
<img src="images/syntax/literal-value.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>numeric-literal:</h4><blockquote>
<img src="images/syntax/numeric-literal.gif"></img><br></br><br></br>
See also: <a href="lang_expr.html#litvalue">lang_expr.html#litvalue</a>
</blockquote>
<h4>insert-stmt:</h4><blockquote>
<img src="images/syntax/insert-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#select-stmt">select-stmt</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_insert.html">lang_insert.html</a>
</blockquote>
<h4>pragma-stmt:</h4><blockquote>
<img src="images/syntax/pragma-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#pragma-value">pragma-value</a><br></br>
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<h4>pragma-value:</h4><blockquote>
<img src="images/syntax/pragma-value.gif"></img><br></br>
Used by: <a href="#pragma-stmt">pragma-stmt</a><br></br>
References: <a href="#signed-number">signed-number</a><br></br>
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<h4>reindex-stmt:</h4><blockquote>
<img src="images/syntax/reindex-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_reindex.html">lang_reindex.html</a>
</blockquote>
<h4>select-stmt:</h4><blockquote>
<img src="images/syntax/select-stmt.gif"></img><br></br>
Used by: <a href="#common-table-expression">common-table-expression</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#sql-stmt">sql-stmt</a> <a href="#table-or-subquery">table-or-subquery</a> <a href="#with-clause">with-clause</a><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>join-clause:</h4><blockquote>
<img src="images/syntax/join-clause.gif"></img><br></br>
Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
References: <a href="#join-constraint">join-constraint</a> <a href="#join-operator">join-operator</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>select-core:</h4><blockquote>
<img src="images/syntax/select-core.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a>
</blockquote>
<h4>factored-select-stmt:</h4><blockquote>
<img src="images/syntax/factored-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html">lang_select.html</a>
</blockquote>
<h4>simple-select-stmt:</h4><blockquote>
<img src="images/syntax/simple-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a>
</blockquote>
<h4>compound-select-stmt:</h4><blockquote>
<img src="images/syntax/compound-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html#compound">lang_select.html#compound</a>
</blockquote>
<h4>table-or-subquery:</h4><blockquote>
<img src="images/syntax/table-or-subquery.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br>
References: <a href="#join-clause">join-clause</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>result-column:</h4><blockquote>
<img src="images/syntax/result-column.gif"></img><br></br>
Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>join-operator:</h4><blockquote>
<img src="images/syntax/join-operator.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>join-constraint:</h4><blockquote>
<img src="images/syntax/join-constraint.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>ordering-term:</h4><blockquote>
<img src="images/syntax/ordering-term.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>compound-operator:</h4><blockquote>
<img src="images/syntax/compound-operator.gif"></img><br></br>
Used by: <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<h4>update-stmt:</h4><blockquote>
<img src="images/syntax/update-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_update.html">lang_update.html</a>
</blockquote>
<h4>update-stmt-limited:</h4><blockquote>
<img src="images/syntax/update-stmt-limited.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_update.html">lang_update.html</a>
</blockquote>
<h4>qualified-table-name:</h4><blockquote>
<img src="images/syntax/qualified-table-name.gif"></img><br></br>
Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_indexedby.html">lang_indexedby.html</a> <a href="lang_update.html">lang_update.html</a>
</blockquote>
<h4>vacuum-stmt:</h4><blockquote>
<img src="images/syntax/vacuum-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_vacuum.html">lang_vacuum.html</a>
</blockquote>
<h4>comment-syntax:</h4><blockquote>
<img src="images/syntax/comment-syntax.gif"></img><br></br><br></br>
See also: <a href="lang_comment.html">lang_comment.html</a>
</blockquote>
|
