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>Syntax Diagrams For SQLite</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>
123
<h1 align=center>Syntax Diagrams For SQLite</h1>
125
<a name="sql-stmt-list"></a>
126
<h4>sql-stmt-list:</h4><blockquote>
127
<img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br>
128
References: <a href="#sql-stmt">sql-stmt</a><br></br>
129
See also: <a href="lang.html">lang.html</a>
132
<a name="sql-stmt"></a>
133
<h4>sql-stmt:</h4><blockquote>
134
<img src="images/syntax/sql-stmt.gif"></img><br></br>
135
Used by: <a href="#sql-stmt-list">sql-stmt-list</a><br></br>
136
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>
137
See also: <a href="lang.html">lang.html</a> <a href="lang_explain.html">lang_explain.html</a>
140
<a name="alter-table-stmt"></a>
141
<h4>alter-table-stmt:</h4><blockquote>
142
<img src="images/syntax/alter-table-stmt.gif"></img><br></br>
143
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
144
References: <a href="#column-def">column-def</a><br></br>
145
See also: <a href="lang_altertable.html">lang_altertable.html</a>
148
<a name="analyze-stmt"></a>
149
<h4>analyze-stmt:</h4><blockquote>
150
<img src="images/syntax/analyze-stmt.gif"></img><br></br>
151
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
152
See also: <a href="lang_analyze.html">lang_analyze.html</a>
155
<a name="attach-stmt"></a>
156
<h4>attach-stmt:</h4><blockquote>
157
<img src="images/syntax/attach-stmt.gif"></img><br></br>
158
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
159
References: <a href="#expr">expr</a><br></br>
160
See also: <a href="lang_attach.html">lang_attach.html</a>
163
<a name="begin-stmt"></a>
164
<h4>begin-stmt:</h4><blockquote>
165
<img src="images/syntax/begin-stmt.gif"></img><br></br>
166
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
167
See also: <a href="lang_transaction.html">lang_transaction.html</a>
170
<a name="commit-stmt"></a>
171
<h4>commit-stmt:</h4><blockquote>
172
<img src="images/syntax/commit-stmt.gif"></img><br></br>
173
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
174
See also: <a href="lang_transaction.html">lang_transaction.html</a>
177
<a name="rollback-stmt"></a>
178
<h4>rollback-stmt:</h4><blockquote>
179
<img src="images/syntax/rollback-stmt.gif"></img><br></br>
180
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
181
See also: <a href="lang_savepoint.html">lang_savepoint.html</a> <a href="lang_transaction.html">lang_transaction.html</a>
184
<a name="savepoint-stmt"></a>
185
<h4>savepoint-stmt:</h4><blockquote>
186
<img src="images/syntax/savepoint-stmt.gif"></img><br></br>
187
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
188
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
191
<a name="release-stmt"></a>
192
<h4>release-stmt:</h4><blockquote>
193
<img src="images/syntax/release-stmt.gif"></img><br></br>
194
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
195
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
198
<a name="create-index-stmt"></a>
199
<h4>create-index-stmt:</h4><blockquote>
200
<img src="images/syntax/create-index-stmt.gif"></img><br></br>
201
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
202
References: <a href="#indexed-column">indexed-column</a><br></br>
203
See also: <a href="lang_createindex.html">lang_createindex.html</a>
206
<a name="indexed-column"></a>
207
<h4>indexed-column:</h4><blockquote>
208
<img src="images/syntax/indexed-column.gif"></img><br></br>
209
Used by: <a href="#create-index-stmt">create-index-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
210
See also: <a href="lang_createindex.html">lang_createindex.html</a>
213
<a name="create-table-stmt"></a>
214
<h4>create-table-stmt:</h4><blockquote>
215
<img src="images/syntax/create-table-stmt.gif"></img><br></br>
216
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
217
References: <a href="#column-def">column-def</a> <a href="#select-stmt">select-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
218
See also: <a href="lang_createtable.html">lang_createtable.html</a>
221
<a name="column-def"></a>
222
<h4>column-def:</h4><blockquote>
223
<img src="images/syntax/column-def.gif"></img><br></br>
224
Used by: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#create-table-stmt">create-table-stmt</a><br></br>
225
References: <a href="#column-constraint">column-constraint</a> <a href="#type-name">type-name</a><br></br>
226
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>
229
<a name="type-name"></a>
230
<h4>type-name:</h4><blockquote>
231
<img src="images/syntax/type-name.gif"></img><br></br>
232
Used by: <a href="#column-def">column-def</a> <a href="#expr">expr</a><br></br>
233
References: <a href="#signed-number">signed-number</a><br></br>
234
See also: <a href="lang_createtable.html">lang_createtable.html</a>
237
<a name="column-constraint"></a>
238
<h4>column-constraint:</h4><blockquote>
239
<img src="images/syntax/column-constraint.gif"></img><br></br>
240
Used by: <a href="#column-def">column-def</a><br></br>
241
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>
242
See also: <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
245
<a name="signed-number"></a>
246
<h4>signed-number:</h4><blockquote>
247
<img src="images/syntax/signed-number.gif"></img><br></br>
248
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>
249
See also: <a href="lang_expr.html">lang_expr.html</a>
252
<a name="table-constraint"></a>
253
<h4>table-constraint:</h4><blockquote>
254
<img src="images/syntax/table-constraint.gif"></img><br></br>
255
Used by: <a href="#create-table-stmt">create-table-stmt</a><br></br>
256
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>
257
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>
260
<a name="foreign-key-clause"></a>
261
<h4>foreign-key-clause:</h4><blockquote>
262
<img src="images/syntax/foreign-key-clause.gif"></img><br></br>
263
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
264
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a>
267
<a name="conflict-clause"></a>
268
<h4>conflict-clause:</h4><blockquote>
269
<img src="images/syntax/conflict-clause.gif"></img><br></br>
270
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
271
See also: <a href="lang_conflict.html">lang_conflict.html</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a>
274
<a name="create-trigger-stmt"></a>
275
<h4>create-trigger-stmt:</h4><blockquote>
276
<img src="images/syntax/create-trigger-stmt.gif"></img><br></br>
277
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
278
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>
279
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a>
282
<a name="create-view-stmt"></a>
283
<h4>create-view-stmt:</h4><blockquote>
284
<img src="images/syntax/create-view-stmt.gif"></img><br></br>
285
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
286
References: <a href="#select-stmt">select-stmt</a><br></br>
287
See also: <a href="lang_createview.html">lang_createview.html</a>
290
<a name="create-virtual-table-stmt"></a>
291
<h4>create-virtual-table-stmt:</h4><blockquote>
292
<img src="images/syntax/create-virtual-table-stmt.gif"></img><br></br>
293
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
294
See also: <a href="lang_createvtab.html">lang_createvtab.html</a>
297
<a name="delete-stmt"></a>
298
<h4>delete-stmt:</h4><blockquote>
299
<img src="images/syntax/delete-stmt.gif"></img><br></br>
300
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
301
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a><br></br>
302
See also: <a href="lang_delete.html">lang_delete.html</a>
305
<a name="delete-stmt-limited"></a>
306
<h4>delete-stmt-limited:</h4><blockquote>
307
<img src="images/syntax/delete-stmt-limited.gif"></img><br></br>
308
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
309
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a><br></br>
310
See also: <a href="lang_delete.html">lang_delete.html</a>
313
<a name="detach-stmt"></a>
314
<h4>detach-stmt:</h4><blockquote>
315
<img src="images/syntax/detach-stmt.gif"></img><br></br>
316
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
317
See also: <a href="lang_detach.html">lang_detach.html</a>
320
<a name="drop-index-stmt"></a>
321
<h4>drop-index-stmt:</h4><blockquote>
322
<img src="images/syntax/drop-index-stmt.gif"></img><br></br>
323
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
324
See also: <a href="lang_dropindex.html">lang_dropindex.html</a>
327
<a name="drop-table-stmt"></a>
328
<h4>drop-table-stmt:</h4><blockquote>
329
<img src="images/syntax/drop-table-stmt.gif"></img><br></br>
330
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
331
See also: <a href="lang_droptable.html">lang_droptable.html</a>
334
<a name="drop-trigger-stmt"></a>
335
<h4>drop-trigger-stmt:</h4><blockquote>
336
<img src="images/syntax/drop-trigger-stmt.gif"></img><br></br>
337
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
338
See also: <a href="lang_droptrigger.html">lang_droptrigger.html</a>
341
<a name="drop-view-stmt"></a>
342
<h4>drop-view-stmt:</h4><blockquote>
343
<img src="images/syntax/drop-view-stmt.gif"></img><br></br>
344
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
345
See also: <a href="lang_dropview.html">lang_dropview.html</a>
349
<h4>expr:</h4><blockquote>
350
<img src="images/syntax/expr.gif"></img><br></br>
351
Used by: <a href="#attach-stmt">attach-stmt</a> <a href="#column-constraint">column-constraint</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="#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="#table-constraint">table-constraint</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
352
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>
353
See also: <a href="lang_expr.html">lang_expr.html</a>
356
<a name="raise-function"></a>
357
<h4>raise-function:</h4><blockquote>
358
<img src="images/syntax/raise-function.gif"></img><br></br>
359
Used by: <a href="#expr">expr</a><br></br>
360
See also: <a href="lang_createtrigger.html#undef_before">lang_createtrigger.html#undef_before</a> <a href="lang_expr.html">lang_expr.html</a>
363
<a name="literal-value"></a>
364
<h4>literal-value:</h4><blockquote>
365
<img src="images/syntax/literal-value.gif"></img><br></br>
366
Used by: <a href="#column-constraint">column-constraint</a> <a href="#expr">expr</a><br></br>
367
See also: <a href="lang_expr.html">lang_expr.html</a>
370
<a name="numeric-literal"></a>
371
<h4>numeric-literal:</h4><blockquote>
372
<img src="images/syntax/numeric-literal.gif"></img><br></br><br></br>
373
See also: <a href="lang_expr.html#litvalue">lang_expr.html#litvalue</a>
376
<a name="insert-stmt"></a>
377
<h4>insert-stmt:</h4><blockquote>
378
<img src="images/syntax/insert-stmt.gif"></img><br></br>
379
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
380
References: <a href="#expr">expr</a> <a href="#select-stmt">select-stmt</a><br></br>
381
See also: <a href="lang_insert.html">lang_insert.html</a>
384
<a name="pragma-stmt"></a>
385
<h4>pragma-stmt:</h4><blockquote>
386
<img src="images/syntax/pragma-stmt.gif"></img><br></br>
387
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
388
References: <a href="#pragma-value">pragma-value</a><br></br>
389
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
392
<a name="pragma-value"></a>
393
<h4>pragma-value:</h4><blockquote>
394
<img src="images/syntax/pragma-value.gif"></img><br></br>
395
Used by: <a href="#pragma-stmt">pragma-stmt</a><br></br>
396
References: <a href="#signed-number">signed-number</a><br></br>
397
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
400
<a name="reindex-stmt"></a>
401
<h4>reindex-stmt:</h4><blockquote>
402
<img src="images/syntax/reindex-stmt.gif"></img><br></br>
403
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
404
See also: <a href="lang_reindex.html">lang_reindex.html</a>
407
<a name="select-stmt"></a>
408
<h4>select-stmt:</h4><blockquote>
409
<img src="images/syntax/select-stmt.gif"></img><br></br>
410
Used by: <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="#single-source">single-source</a> <a href="#sql-stmt">sql-stmt</a><br></br>
411
References: <a href="#compound-operator">compound-operator</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
412
See also: <a href="lang_select.html">lang_select.html</a>
415
<a name="select-core"></a>
416
<h4>select-core:</h4><blockquote>
417
<img src="images/syntax/select-core.gif"></img><br></br>
418
Used by: <a href="#select-stmt">select-stmt</a><br></br>
419
References: <a href="#expr">expr</a> <a href="#join-source">join-source</a> <a href="#result-column">result-column</a><br></br>
420
See also: <a href="lang_select.html">lang_select.html</a>
423
<a name="result-column"></a>
424
<h4>result-column:</h4><blockquote>
425
<img src="images/syntax/result-column.gif"></img><br></br>
426
Used by: <a href="#select-core">select-core</a><br></br>
427
References: <a href="#expr">expr</a><br></br>
428
See also: <a href="lang_select.html">lang_select.html</a>
431
<a name="join-source"></a>
432
<h4>join-source:</h4><blockquote>
433
<img src="images/syntax/join-source.gif"></img><br></br>
434
Used by: <a href="#select-core">select-core</a> <a href="#single-source">single-source</a><br></br>
435
References: <a href="#join-constraint">join-constraint</a> <a href="#join-op">join-op</a> <a href="#single-source">single-source</a><br></br>
436
See also: <a href="lang_select.html">lang_select.html</a>
439
<a name="single-source"></a>
440
<h4>single-source:</h4><blockquote>
441
<img src="images/syntax/single-source.gif"></img><br></br>
442
Used by: <a href="#join-source">join-source</a><br></br>
443
References: <a href="#join-source">join-source</a> <a href="#select-stmt">select-stmt</a><br></br>
444
See also: <a href="lang_indexedby.html">lang_indexedby.html</a> <a href="lang_select.html">lang_select.html</a>
447
<a name="join-op"></a>
448
<h4>join-op:</h4><blockquote>
449
<img src="images/syntax/join-op.gif"></img><br></br>
450
Used by: <a href="#join-source">join-source</a><br></br>
451
See also: <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a>
454
<a name="join-constraint"></a>
455
<h4>join-constraint:</h4><blockquote>
456
<img src="images/syntax/join-constraint.gif"></img><br></br>
457
Used by: <a href="#join-source">join-source</a><br></br>
458
References: <a href="#expr">expr</a><br></br>
459
See also: <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a>
462
<a name="ordering-term"></a>
463
<h4>ordering-term:</h4><blockquote>
464
<img src="images/syntax/ordering-term.gif"></img><br></br>
465
Used by: <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
466
References: <a href="#expr">expr</a><br></br>
467
See also: <a href="lang_select.html">lang_select.html</a>
470
<a name="compound-operator"></a>
471
<h4>compound-operator:</h4><blockquote>
472
<img src="images/syntax/compound-operator.gif"></img><br></br>
473
Used by: <a href="#select-stmt">select-stmt</a><br></br>
474
See also: <a href="lang_select.html">lang_select.html</a>
477
<a name="update-stmt"></a>
478
<h4>update-stmt:</h4><blockquote>
479
<img src="images/syntax/update-stmt.gif"></img><br></br>
480
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
481
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a><br></br>
482
See also: <a href="lang_update.html">lang_update.html</a>
485
<a name="update-stmt-limited"></a>
486
<h4>update-stmt-limited:</h4><blockquote>
487
<img src="images/syntax/update-stmt-limited.gif"></img><br></br>
488
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
489
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a><br></br>
490
See also: <a href="lang_update.html">lang_update.html</a>
493
<a name="qualified-table-name"></a>
494
<h4>qualified-table-name:</h4><blockquote>
495
<img src="images/syntax/qualified-table-name.gif"></img><br></br>
496
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>
497
See also: <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>
500
<a name="vacuum-stmt"></a>
501
<h4>vacuum-stmt:</h4><blockquote>
502
<img src="images/syntax/vacuum-stmt.gif"></img><br></br>
503
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
504
See also: <a href="lang_vacuum.html">lang_vacuum.html</a>
507
<a name="comment-syntax"></a>
508
<h4>comment-syntax:</h4><blockquote>
509
<img src="images/syntax/comment-syntax.gif"></img><br></br><br></br>
510
See also: <a href="lang_comment.html">lang_comment.html</a>
added
removed
syntaxdiagrams.html
