syntaxdiagrams.html 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436
  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
  2. <html><head>
  3. <title>SQLite SQL Language Syntax Diagrams</title>
  4. <style type="text/css">
  5. body {
  6. margin: auto;
  7. font-family: Verdana, sans-serif;
  8. padding: 8px 1%;
  9. }
  10. a { color: #45735f }
  11. a:visited { color: #734559 }
  12. .logo { position:absolute; margin:3px; }
  13. .tagline {
  14. float:right;
  15. text-align:right;
  16. font-style:italic;
  17. width:240px;
  18. margin:12px;
  19. margin-top:58px;
  20. }
  21. .toolbar {
  22. font-variant: small-caps;
  23. text-align: center;
  24. line-height: 1.6em;
  25. margin: 0;
  26. padding:1px 8px;
  27. }
  28. .toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
  29. .toolbar a:visited { color: white; }
  30. .toolbar a:hover { color: #80a796; background: white; }
  31. .content { margin: 5%; }
  32. .content dt { font-weight:bold; }
  33. .content dd { margin-bottom: 25px; margin-left:20%; }
  34. .content ul { padding:0px; padding-left: 15px; margin:0px; }
  35. /* rounded corners */
  36. .se { background: url(images/se.png) 100% 100% no-repeat #80a796}
  37. .sw { background: url(images/sw.png) 0% 100% no-repeat }
  38. .ne { background: url(images/ne.png) 100% 0% no-repeat }
  39. .nw { background: url(images/nw.png) 0% 0% no-repeat }
  40. </style>
  41. <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  42. </head>
  43. <body>
  44. <div><!-- container div to satisfy validator -->
  45. <h1>SQLite SQL Language Syntax Diagrams</h1>
  46. <a name="sql-stmt-list"></a>
  47. <h4>sql-stmt-list:</h4><blockquote>
  48. <img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br>
  49. References:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  50. See also:&nbsp;&nbsp; <a href="lang.html">lang.html</a>
  51. </blockquote>
  52. <a name="sql-stmt"></a>
  53. <h4>sql-stmt:</h4><blockquote>
  54. <img src="images/syntax/sql-stmt.gif"></img><br></br>
  55. Used by:&nbsp;&nbsp; <a href="#sql-stmt-list">sql-stmt-list</a><br></br>
  56. References:&nbsp;&nbsp; <a href="#alter-table-stmt">alter-table-stmt</a>&nbsp;&nbsp; <a href="#analyze-stmt">analyze-stmt</a>&nbsp;&nbsp; <a href="#attach-stmt">attach-stmt</a>&nbsp;&nbsp; <a href="#begin-stmt">begin-stmt</a>&nbsp;&nbsp; <a href="#commit-stmt">commit-stmt</a>&nbsp;&nbsp; <a href="#create-index-stmt">create-index-stmt</a>&nbsp;&nbsp; <a href="#create-table-stmt">create-table-stmt</a>&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#create-view-stmt">create-view-stmt</a>&nbsp;&nbsp; <a href="#create-virtual-table-stmt">create-virtual-table-stmt</a>&nbsp;&nbsp; <a href="#delete-stmt">delete-stmt</a>&nbsp;&nbsp; <a href="#delete-stmt-limited">delete-stmt-limited</a>&nbsp;&nbsp; <a href="#detach-stmt">detach-stmt</a>&nbsp;&nbsp; <a href="#drop-index-stmt">drop-index-stmt</a>&nbsp;&nbsp; <a href="#drop-table-stmt">drop-table-stmt</a>&nbsp;&nbsp; <a href="#drop-trigger-stmt">drop-trigger-stmt</a>&nbsp;&nbsp; <a href="#drop-view-stmt">drop-view-stmt</a>&nbsp;&nbsp; <a href="#insert-stmt">insert-stmt</a>&nbsp;&nbsp; <a href="#pragma-stmt">pragma-stmt</a>&nbsp;&nbsp; <a href="#reindex-stmt">reindex-stmt</a>&nbsp;&nbsp; <a href="#release-stmt">release-stmt</a>&nbsp;&nbsp; <a href="#rollback-stmt">rollback-stmt</a>&nbsp;&nbsp; <a href="#savepoint-stmt">savepoint-stmt</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a>&nbsp;&nbsp; <a href="#update-stmt">update-stmt</a>&nbsp;&nbsp; <a href="#update-stmt-limited">update-stmt-limited</a>&nbsp;&nbsp; <a href="#vacuum-stmt">vacuum-stmt</a><br></br>
  57. See also:&nbsp;&nbsp; <a href="lang.html">lang.html</a>&nbsp;&nbsp; <a href="lang_explain.html">lang_explain.html</a>
  58. </blockquote>
  59. <a name="alter-table-stmt"></a>
  60. <h4>alter-table-stmt:</h4><blockquote>
  61. <img src="images/syntax/alter-table-stmt.gif"></img><br></br>
  62. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  63. References:&nbsp;&nbsp; <a href="#column-def">column-def</a><br></br>
  64. See also:&nbsp;&nbsp; <a href="lang_altertable.html">lang_altertable.html</a>
  65. </blockquote>
  66. <a name="analyze-stmt"></a>
  67. <h4>analyze-stmt:</h4><blockquote>
  68. <img src="images/syntax/analyze-stmt.gif"></img><br></br>
  69. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  70. See also:&nbsp;&nbsp; <a href="lang_analyze.html">lang_analyze.html</a>
  71. </blockquote>
  72. <a name="attach-stmt"></a>
  73. <h4>attach-stmt:</h4><blockquote>
  74. <img src="images/syntax/attach-stmt.gif"></img><br></br>
  75. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  76. See also:&nbsp;&nbsp; <a href="lang_attach.html">lang_attach.html</a>
  77. </blockquote>
  78. <a name="begin-stmt"></a>
  79. <h4>begin-stmt:</h4><blockquote>
  80. <img src="images/syntax/begin-stmt.gif"></img><br></br>
  81. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  82. See also:&nbsp;&nbsp; <a href="lang_transaction.html">lang_transaction.html</a>
  83. </blockquote>
  84. <a name="commit-stmt"></a>
  85. <h4>commit-stmt:</h4><blockquote>
  86. <img src="images/syntax/commit-stmt.gif"></img><br></br>
  87. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  88. See also:&nbsp;&nbsp; <a href="lang_transaction.html">lang_transaction.html</a>
  89. </blockquote>
  90. <a name="rollback-stmt"></a>
  91. <h4>rollback-stmt:</h4><blockquote>
  92. <img src="images/syntax/rollback-stmt.gif"></img><br></br>
  93. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  94. See also:&nbsp;&nbsp; <a href="lang_savepoint.html">lang_savepoint.html</a>&nbsp;&nbsp; <a href="lang_transaction.html">lang_transaction.html</a>
  95. </blockquote>
  96. <a name="savepoint-stmt"></a>
  97. <h4>savepoint-stmt:</h4><blockquote>
  98. <img src="images/syntax/savepoint-stmt.gif"></img><br></br>
  99. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  100. See also:&nbsp;&nbsp; <a href="lang_savepoint.html">lang_savepoint.html</a>
  101. </blockquote>
  102. <a name="release-stmt"></a>
  103. <h4>release-stmt:</h4><blockquote>
  104. <img src="images/syntax/release-stmt.gif"></img><br></br>
  105. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  106. See also:&nbsp;&nbsp; <a href="lang_savepoint.html">lang_savepoint.html</a>
  107. </blockquote>
  108. <a name="create-index-stmt"></a>
  109. <h4>create-index-stmt:</h4><blockquote>
  110. <img src="images/syntax/create-index-stmt.gif"></img><br></br>
  111. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  112. References:&nbsp;&nbsp; <a href="#indexed-column">indexed-column</a><br></br>
  113. See also:&nbsp;&nbsp; <a href="lang_createindex.html">lang_createindex.html</a>
  114. </blockquote>
  115. <a name="indexed-column"></a>
  116. <h4>indexed-column:</h4><blockquote>
  117. <img src="images/syntax/indexed-column.gif"></img><br></br>
  118. Used by:&nbsp;&nbsp; <a href="#create-index-stmt">create-index-stmt</a>&nbsp;&nbsp; <a href="#table-constraint">table-constraint</a><br></br>
  119. See also:&nbsp;&nbsp; <a href="lang_createindex.html">lang_createindex.html</a>
  120. </blockquote>
  121. <a name="create-table-stmt"></a>
  122. <h4>create-table-stmt:</h4><blockquote>
  123. <img src="images/syntax/create-table-stmt.gif"></img><br></br>
  124. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  125. References:&nbsp;&nbsp; <a href="#column-def">column-def</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a>&nbsp;&nbsp; <a href="#table-constraint">table-constraint</a><br></br>
  126. See also:&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  127. </blockquote>
  128. <a name="column-def"></a>
  129. <h4>column-def:</h4><blockquote>
  130. <img src="images/syntax/column-def.gif"></img><br></br>
  131. Used by:&nbsp;&nbsp; <a href="#alter-table-stmt">alter-table-stmt</a>&nbsp;&nbsp; <a href="#create-table-stmt">create-table-stmt</a><br></br>
  132. References:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#type-name">type-name</a><br></br>
  133. See also:&nbsp;&nbsp; <a href="lang_altertable.html">lang_altertable.html</a>&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  134. </blockquote>
  135. <a name="type-name"></a>
  136. <h4>type-name:</h4><blockquote>
  137. <img src="images/syntax/type-name.gif"></img><br></br>
  138. Used by:&nbsp;&nbsp; <a href="#column-def">column-def</a>&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  139. References:&nbsp;&nbsp; <a href="#signed-number">signed-number</a><br></br>
  140. See also:&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  141. </blockquote>
  142. <a name="column-constraint"></a>
  143. <h4>column-constraint:</h4><blockquote>
  144. <img src="images/syntax/column-constraint.gif"></img><br></br>
  145. Used by:&nbsp;&nbsp; <a href="#column-def">column-def</a><br></br>
  146. References:&nbsp;&nbsp; <a href="#conflict-clause">conflict-clause</a>&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#foreign-key-clause">foreign-key-clause</a>&nbsp;&nbsp; <a href="#literal-value">literal-value</a>&nbsp;&nbsp; <a href="#signed-number">signed-number</a><br></br>
  147. See also:&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  148. </blockquote>
  149. <a name="signed-number"></a>
  150. <h4>signed-number:</h4><blockquote>
  151. <img src="images/syntax/signed-number.gif"></img><br></br>
  152. Used by:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#pragma-value">pragma-value</a>&nbsp;&nbsp; <a href="#type-name">type-name</a><br></br>
  153. See also:&nbsp;&nbsp; <a href="lang_expr.html">lang_expr.html</a>
  154. </blockquote>
  155. <a name="table-constraint"></a>
  156. <h4>table-constraint:</h4><blockquote>
  157. <img src="images/syntax/table-constraint.gif"></img><br></br>
  158. Used by:&nbsp;&nbsp; <a href="#create-table-stmt">create-table-stmt</a><br></br>
  159. References:&nbsp;&nbsp; <a href="#conflict-clause">conflict-clause</a>&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#foreign-key-clause">foreign-key-clause</a>&nbsp;&nbsp; <a href="#indexed-column">indexed-column</a><br></br>
  160. See also:&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  161. </blockquote>
  162. <a name="foreign-key-clause"></a>
  163. <h4>foreign-key-clause:</h4><blockquote>
  164. <img src="images/syntax/foreign-key-clause.gif"></img><br></br>
  165. Used by:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#table-constraint">table-constraint</a><br></br>
  166. See also:&nbsp;&nbsp; <a href="lang_altertable.html">lang_altertable.html</a>&nbsp;&nbsp; <a href="lang_createtable.html">lang_createtable.html</a>
  167. </blockquote>
  168. <a name="conflict-clause"></a>
  169. <h4>conflict-clause:</h4><blockquote>
  170. <img src="images/syntax/conflict-clause.gif"></img><br></br>
  171. Used by:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#table-constraint">table-constraint</a><br></br>
  172. See also:&nbsp;&nbsp; <a href="lang_conflict.html">lang_conflict.html</a>
  173. </blockquote>
  174. <a name="create-trigger-stmt"></a>
  175. <h4>create-trigger-stmt:</h4><blockquote>
  176. <img src="images/syntax/create-trigger-stmt.gif"></img><br></br>
  177. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  178. References:&nbsp;&nbsp; <a href="#delete-stmt">delete-stmt</a>&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#insert-stmt">insert-stmt</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a>&nbsp;&nbsp; <a href="#update-stmt">update-stmt</a><br></br>
  179. See also:&nbsp;&nbsp; <a href="lang_createtrigger.html">lang_createtrigger.html</a>
  180. </blockquote>
  181. <a name="create-view-stmt"></a>
  182. <h4>create-view-stmt:</h4><blockquote>
  183. <img src="images/syntax/create-view-stmt.gif"></img><br></br>
  184. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  185. References:&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a><br></br>
  186. See also:&nbsp;&nbsp; <a href="lang_createview.html">lang_createview.html</a>
  187. </blockquote>
  188. <a name="create-virtual-table-stmt"></a>
  189. <h4>create-virtual-table-stmt:</h4><blockquote>
  190. <img src="images/syntax/create-virtual-table-stmt.gif"></img><br></br>
  191. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  192. See also:&nbsp;&nbsp; <a href="lang_createvtab.html">lang_createvtab.html</a>
  193. </blockquote>
  194. <a name="delete-stmt"></a>
  195. <h4>delete-stmt:</h4><blockquote>
  196. <img src="images/syntax/delete-stmt.gif"></img><br></br>
  197. Used by:&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  198. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#qualified-table-name">qualified-table-name</a><br></br>
  199. See also:&nbsp;&nbsp; <a href="lang_delete.html">lang_delete.html</a>
  200. </blockquote>
  201. <a name="delete-stmt-limited"></a>
  202. <h4>delete-stmt-limited:</h4><blockquote>
  203. <img src="images/syntax/delete-stmt-limited.gif"></img><br></br>
  204. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  205. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#ordering-term">ordering-term</a>&nbsp;&nbsp; <a href="#qualified-table-name">qualified-table-name</a><br></br>
  206. See also:&nbsp;&nbsp; <a href="lang_delete.html#trucateopt">lang_delete.html#trucateopt</a>
  207. </blockquote>
  208. <a name="detach-stmt"></a>
  209. <h4>detach-stmt:</h4><blockquote>
  210. <img src="images/syntax/detach-stmt.gif"></img><br></br>
  211. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  212. See also:&nbsp;&nbsp; <a href="lang_detach.html">lang_detach.html</a>
  213. </blockquote>
  214. <a name="drop-index-stmt"></a>
  215. <h4>drop-index-stmt:</h4><blockquote>
  216. <img src="images/syntax/drop-index-stmt.gif"></img><br></br>
  217. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  218. See also:&nbsp;&nbsp; <a href="lang_dropindex.html">lang_dropindex.html</a>
  219. </blockquote>
  220. <a name="drop-table-stmt"></a>
  221. <h4>drop-table-stmt:</h4><blockquote>
  222. <img src="images/syntax/drop-table-stmt.gif"></img><br></br>
  223. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  224. See also:&nbsp;&nbsp; <a href="lang_droptable.html">lang_droptable.html</a>
  225. </blockquote>
  226. <a name="drop-trigger-stmt"></a>
  227. <h4>drop-trigger-stmt:</h4><blockquote>
  228. <img src="images/syntax/drop-trigger-stmt.gif"></img><br></br>
  229. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  230. See also:&nbsp;&nbsp; <a href="lang_droptrigger.html">lang_droptrigger.html</a>
  231. </blockquote>
  232. <a name="drop-view-stmt"></a>
  233. <h4>drop-view-stmt:</h4><blockquote>
  234. <img src="images/syntax/drop-view-stmt.gif"></img><br></br>
  235. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  236. See also:&nbsp;&nbsp; <a href="lang_dropview.html">lang_dropview.html</a>
  237. </blockquote>
  238. <a name="expr"></a>
  239. <h4>expr:</h4><blockquote>
  240. <img src="images/syntax/expr.gif"></img><br></br>
  241. Used by:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#delete-stmt">delete-stmt</a>&nbsp;&nbsp; <a href="#delete-stmt-limited">delete-stmt-limited</a>&nbsp;&nbsp; <a href="#insert-stmt">insert-stmt</a>&nbsp;&nbsp; <a href="#join-constraint">join-constraint</a>&nbsp;&nbsp; <a href="#ordering-term">ordering-term</a>&nbsp;&nbsp; <a href="#result-column">result-column</a>&nbsp;&nbsp; <a href="#select-core">select-core</a>&nbsp;&nbsp; <a href="#table-constraint">table-constraint</a>&nbsp;&nbsp; <a href="#update-stmt">update-stmt</a>&nbsp;&nbsp; <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
  242. References:&nbsp;&nbsp; <a href="#literal-value">literal-value</a>&nbsp;&nbsp; <a href="#raise-function">raise-function</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a>&nbsp;&nbsp; <a href="#type-name">type-name</a><br></br>
  243. See also:&nbsp;&nbsp; <a href="lang_expr.html">lang_expr.html</a>
  244. </blockquote>
  245. <a name="raise-function"></a>
  246. <h4>raise-function:</h4><blockquote>
  247. <img src="images/syntax/raise-function.gif"></img><br></br>
  248. Used by:&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  249. See also:&nbsp;&nbsp; <a href="lang_createtrigger.html#undef_before">lang_createtrigger.html#undef_before</a>&nbsp;&nbsp; <a href="lang_expr.html">lang_expr.html</a>
  250. </blockquote>
  251. <a name="literal-value"></a>
  252. <h4>literal-value:</h4><blockquote>
  253. <img src="images/syntax/literal-value.gif"></img><br></br>
  254. Used by:&nbsp;&nbsp; <a href="#column-constraint">column-constraint</a>&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  255. See also:&nbsp;&nbsp; <a href="lang_expr.html">lang_expr.html</a>
  256. </blockquote>
  257. <a name="insert-stmt"></a>
  258. <h4>insert-stmt:</h4><blockquote>
  259. <img src="images/syntax/insert-stmt.gif"></img><br></br>
  260. Used by:&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  261. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a><br></br>
  262. See also:&nbsp;&nbsp; <a href="lang_insert.html">lang_insert.html</a>
  263. </blockquote>
  264. <a name="pragma-stmt"></a>
  265. <h4>pragma-stmt:</h4><blockquote>
  266. <img src="images/syntax/pragma-stmt.gif"></img><br></br>
  267. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  268. References:&nbsp;&nbsp; <a href="#pragma-value">pragma-value</a><br></br>
  269. See also:&nbsp;&nbsp; <a href="pragma.html#syntax">pragma.html#syntax</a>
  270. </blockquote>
  271. <a name="pragma-value"></a>
  272. <h4>pragma-value:</h4><blockquote>
  273. <img src="images/syntax/pragma-value.gif"></img><br></br>
  274. Used by:&nbsp;&nbsp; <a href="#pragma-stmt">pragma-stmt</a><br></br>
  275. References:&nbsp;&nbsp; <a href="#signed-number">signed-number</a><br></br>
  276. See also:&nbsp;&nbsp; <a href="pragma.html#syntax">pragma.html#syntax</a>
  277. </blockquote>
  278. <a name="reindex-stmt"></a>
  279. <h4>reindex-stmt:</h4><blockquote>
  280. <img src="images/syntax/reindex-stmt.gif"></img><br></br>
  281. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  282. See also:&nbsp;&nbsp; <a href="lang_reindex.html">lang_reindex.html</a>
  283. </blockquote>
  284. <a name="select-stmt"></a>
  285. <h4>select-stmt:</h4><blockquote>
  286. <img src="images/syntax/select-stmt.gif"></img><br></br>
  287. Used by:&nbsp;&nbsp; <a href="#create-table-stmt">create-table-stmt</a>&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#create-view-stmt">create-view-stmt</a>&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#insert-stmt">insert-stmt</a>&nbsp;&nbsp; <a href="#single-source">single-source</a>&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  288. References:&nbsp;&nbsp; <a href="#compound-operator">compound-operator</a>&nbsp;&nbsp; <a href="#ordering-term">ordering-term</a>&nbsp;&nbsp; <a href="#select-core">select-core</a><br></br>
  289. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  290. </blockquote>
  291. <a name="select-core"></a>
  292. <h4>select-core:</h4><blockquote>
  293. <img src="images/syntax/select-core.gif"></img><br></br>
  294. Used by:&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a><br></br>
  295. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#join-source">join-source</a>&nbsp;&nbsp; <a href="#ordering-term">ordering-term</a>&nbsp;&nbsp; <a href="#result-column">result-column</a><br></br>
  296. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  297. </blockquote>
  298. <a name="result-column"></a>
  299. <h4>result-column:</h4><blockquote>
  300. <img src="images/syntax/result-column.gif"></img><br></br>
  301. Used by:&nbsp;&nbsp; <a href="#select-core">select-core</a><br></br>
  302. References:&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  303. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  304. </blockquote>
  305. <a name="join-source"></a>
  306. <h4>join-source:</h4><blockquote>
  307. <img src="images/syntax/join-source.gif"></img><br></br>
  308. Used by:&nbsp;&nbsp; <a href="#select-core">select-core</a>&nbsp;&nbsp; <a href="#single-source">single-source</a><br></br>
  309. References:&nbsp;&nbsp; <a href="#join-constraint">join-constraint</a>&nbsp;&nbsp; <a href="#join-op">join-op</a>&nbsp;&nbsp; <a href="#single-source">single-source</a><br></br>
  310. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  311. </blockquote>
  312. <a name="single-source"></a>
  313. <h4>single-source:</h4><blockquote>
  314. <img src="images/syntax/single-source.gif"></img><br></br>
  315. Used by:&nbsp;&nbsp; <a href="#join-source">join-source</a><br></br>
  316. References:&nbsp;&nbsp; <a href="#join-source">join-source</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a><br></br>
  317. See also:&nbsp;&nbsp; <a href="lang_indexedby.html">lang_indexedby.html</a>&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  318. </blockquote>
  319. <a name="join-op"></a>
  320. <h4>join-op:</h4><blockquote>
  321. <img src="images/syntax/join-op.gif"></img><br></br>
  322. Used by:&nbsp;&nbsp; <a href="#join-source">join-source</a><br></br>
  323. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  324. </blockquote>
  325. <a name="join-constraint"></a>
  326. <h4>join-constraint:</h4><blockquote>
  327. <img src="images/syntax/join-constraint.gif"></img><br></br>
  328. Used by:&nbsp;&nbsp; <a href="#join-source">join-source</a><br></br>
  329. References:&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  330. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  331. </blockquote>
  332. <a name="ordering-term"></a>
  333. <h4>ordering-term:</h4><blockquote>
  334. <img src="images/syntax/ordering-term.gif"></img><br></br>
  335. Used by:&nbsp;&nbsp; <a href="#delete-stmt-limited">delete-stmt-limited</a>&nbsp;&nbsp; <a href="#select-core">select-core</a>&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a>&nbsp;&nbsp; <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
  336. References:&nbsp;&nbsp; <a href="#expr">expr</a><br></br>
  337. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  338. </blockquote>
  339. <a name="compound-operator"></a>
  340. <h4>compound-operator:</h4><blockquote>
  341. <img src="images/syntax/compound-operator.gif"></img><br></br>
  342. Used by:&nbsp;&nbsp; <a href="#select-stmt">select-stmt</a><br></br>
  343. See also:&nbsp;&nbsp; <a href="lang_select.html">lang_select.html</a>
  344. </blockquote>
  345. <a name="update-stmt"></a>
  346. <h4>update-stmt:</h4><blockquote>
  347. <img src="images/syntax/update-stmt.gif"></img><br></br>
  348. Used by:&nbsp;&nbsp; <a href="#create-trigger-stmt">create-trigger-stmt</a>&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  349. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#qualified-table-name">qualified-table-name</a><br></br>
  350. See also:&nbsp;&nbsp; <a href="lang_update.html">lang_update.html</a>
  351. </blockquote>
  352. <a name="update-stmt-limited"></a>
  353. <h4>update-stmt-limited:</h4><blockquote>
  354. <img src="images/syntax/update-stmt-limited.gif"></img><br></br>
  355. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  356. References:&nbsp;&nbsp; <a href="#expr">expr</a>&nbsp;&nbsp; <a href="#ordering-term">ordering-term</a>&nbsp;&nbsp; <a href="#qualified-table-name">qualified-table-name</a><br></br>
  357. See also:&nbsp;&nbsp; <a href="lang_update.html">lang_update.html</a>
  358. </blockquote>
  359. <a name="qualified-table-name"></a>
  360. <h4>qualified-table-name:</h4><blockquote>
  361. <img src="images/syntax/qualified-table-name.gif"></img><br></br>
  362. Used by:&nbsp;&nbsp; <a href="#delete-stmt">delete-stmt</a>&nbsp;&nbsp; <a href="#delete-stmt-limited">delete-stmt-limited</a>&nbsp;&nbsp; <a href="#update-stmt">update-stmt</a>&nbsp;&nbsp; <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
  363. See also:&nbsp;&nbsp; <a href="lang_delete.html">lang_delete.html</a>&nbsp;&nbsp; <a href="lang_indexedby.html">lang_indexedby.html</a>&nbsp;&nbsp; <a href="lang_update.html">lang_update.html</a>
  364. </blockquote>
  365. <a name="vacuum-stmt"></a>
  366. <h4>vacuum-stmt:</h4><blockquote>
  367. <img src="images/syntax/vacuum-stmt.gif"></img><br></br>
  368. Used by:&nbsp;&nbsp; <a href="#sql-stmt">sql-stmt</a><br></br>
  369. See also:&nbsp;&nbsp; <a href="lang_vacuum.html">lang_vacuum.html</a>
  370. </blockquote>
  371. <a name="comment-syntax"></a>
  372. <h4>comment-syntax:</h4><blockquote>
  373. <img src="images/syntax/comment-syntax.gif"></img><br></br><br></br>
  374. See also:&nbsp;&nbsp; <a href="lang_comment.html">lang_comment.html</a>
  375. </blockquote>