Debian Codegraph @

www/lang.html

raw
1 <!DOCTYPE html>
2 <html><head>
3 <meta name="viewport" content="width=device-width, initial-scale=1.0">
4 <meta http-equiv="content-type" content="text/html; charset=UTF-8">
5 <link href="sqlite.css" rel="stylesheet">
6 <title>Query Language Understood by SQLite</title>
7 <!-- path= -->
8 </head>
9 <body>
10 <div class=nosearch>
11 <a href="index.html">
12 <img class="logo" src="images/sqlite370_banner.svg" alt="SQLite" border="0">
13 </a>
14 <div><!-- IE hack to prevent disappearing logo --></div>
15 <div class="tagline desktoponly">
16 Small. Fast. Reliable.<br>Choose any three.
17 </div>
18 <div class="menu mainmenu">
19 <ul>
20 <li><a href="index.html">Home</a>
21 <li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
22 <li class='wideonly'><a href='about.html'>About</a>
23 <li class='desktoponly'><a href="docs.html">Documentation</a>
24 <li class='desktoponly'><a href="download.html">Download</a>
25 <li class='wideonly'><a href='copyright.html'>License</a>
26 <li class='desktoponly'><a href="support.html">Support</a>
27 <li class='desktoponly'><a href="prosupport.html">Purchase</a>
28 <li class='search' id='search_menubutton'>
29 <a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
30 </ul>
31 </div>
32 <div class="menu submenu" id="submenu">
33 <ul>
34 <li><a href='about.html'>About</a>
35 <li><a href='docs.html'>Documentation</a>
36 <li><a href='download.html'>Download</a>
37 <li><a href='support.html'>Support</a>
38 <li><a href='prosupport.html'>Purchase</a>
39 </ul>
40 </div>
41 <div class="searchmenu" id="searchmenu">
42 <form method="GET" action="search">
43 <select name="s" id="searchtype">
44 <option value="d">Search Documentation</option>
45 <option value="c">Search Changelog</option>
46 </select>
47 <input type="text" name="q" id="searchbox" value="">
48 <input type="submit" value="Go">
49 </form>
50 </div>
51 </div>
52 <script>
53 function toggle_div(nm) {
54 var w = document.getElementById(nm);
55 if( w.style.display=="block" ){
56 w.style.display = "none";
57 }else{
58 w.style.display = "block";
59 }
60 }
61 function toggle_search() {
62 var w = document.getElementById("searchmenu");
63 if( w.style.display=="block" ){
64 w.style.display = "none";
65 } else {
66 w.style.display = "block";
67 setTimeout(function(){
68 document.getElementById("searchbox").focus()
69 }, 30);
70 }
71 }
72 function div_off(nm){document.getElementById(nm).style.display="none";}
73 window.onbeforeunload = function(e){div_off("submenu");}
74 /* Disable the Search feature if we are not operating from CGI, since */
75 /* Search is accomplished using CGI and will not work without it. */
76 if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
77 document.getElementById("search_menubutton").style.display = "none";
78 }
79 /* Used by the Hide/Show button beside syntax diagrams, to toggle the */
80 function hideorshow(btn,obj){
81 var x = document.getElementById(obj);
82 var b = document.getElementById(btn);
83 if( x.style.display!='none' ){
84 x.style.display = 'none';
85 b.innerHTML='show';
86 }else{
87 x.style.display = '';
88 b.innerHTML='hide';
89 }
90 return false;
91 }
92 var antiRobot = 0;
93 function antiRobotGo(){
94 if( antiRobot!=3 ) return;
95 antiRobot = 7;
96 var j = document.getElementById("mtimelink");
97 if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
98 }
99 function antiRobotDefense(){
100 document.body.onmousedown=function(){
101 antiRobot |= 2;
102 antiRobotGo();
103 document.body.onmousedown=null;
104 }
105 document.body.onmousemove=function(){
106 antiRobot |= 2;
107 antiRobotGo();
108 document.body.onmousemove=null;
109 }
110 setTimeout(function(){
111 antiRobot |= 1;
112 antiRobotGo();
113 }, 100)
114 antiRobotGo();
115 }
116 antiRobotDefense();
117 </script>
118
119
120 <h1 align=center>SQL As Understood By SQLite</h1>
121
122 <p>SQLite understands most of the standard SQL
123 language. But it does <a href="omitted.html">omit some features</a>
124 while at the same time
125 adding a few features of its own. This document attempts to
126 describe precisely what parts of the SQL language SQLite does
127 and does not support. A list of <a href="lang_keywords.html">SQL keywords</a> is
128 also provided. The SQL language syntax is described by
129 <a href="syntaxdiagrams.html">syntax diagrams</a>.
130
131 <p>The following syntax documentation topics are available:</p>
132
133 <table width="100%" cellpadding="5" border="0">
134 <tr><td valign="top"><ul>
135
136 <div class='columns' style='columns: 17em auto;'>
137 <ul style='padding-top:0;'>
138 <li><a href='lang_aggfunc.html'>aggregate functions</a></li>
139 <li><a href='lang_altertable.html'>ALTER TABLE</a></li>
140 <li><a href='lang_analyze.html'>ANALYZE</a></li>
141 <li><a href='lang_attach.html'>ATTACH DATABASE</a></li>
142 <li><a href='lang_transaction.html'>BEGIN TRANSACTION</a></li>
143 <li><a href='lang_comment.html'>comment</a></li>
144 <li><a href='lang_transaction.html'>COMMIT TRANSACTION</a></li>
145 <li><a href='lang_corefunc.html'>core functions</a></li>
146 <li><a href='lang_createindex.html'>CREATE INDEX</a></li>
147 <li><a href='lang_createtable.html'>CREATE TABLE</a></li>
148 <li><a href='lang_createtrigger.html'>CREATE TRIGGER</a></li>
149 <li><a href='lang_createview.html'>CREATE VIEW</a></li>
150 <li><a href='lang_createvtab.html'>CREATE VIRTUAL TABLE</a></li>
151 <li><a href='lang_datefunc.html'>date and time functions</a></li>
152 <li><a href='lang_delete.html'>DELETE</a></li>
153 <li><a href='lang_detach.html'>DETACH DATABASE</a></li>
154 <li><a href='lang_dropindex.html'>DROP INDEX</a></li>
155 <li><a href='lang_droptable.html'>DROP TABLE</a></li>
156 <li><a href='lang_droptrigger.html'>DROP TRIGGER</a></li>
157 <li><a href='lang_dropview.html'>DROP VIEW</a></li>
158 <li><a href='lang_transaction.html'>END TRANSACTION</a></li>
159 <li><a href='lang_explain.html'>EXPLAIN</a></li>
160 <li><a href='lang_expr.html'>expression</a></li>
161 <li><a href='lang_indexedby.html'>INDEXED BY</a></li>
162 <li><a href='lang_insert.html'>INSERT</a></li>
163 <li><a href='json1.html'>JSON functions</a></li>
164 <li><a href='lang_keywords.html'>keywords</a></li>
165 <li><a href='lang_mathfunc.html'>math functions</a></li>
166 <li><a href='lang_conflict.html'>ON CONFLICT clause</a></li>
167 <li><a href='pragma.html#syntax'>PRAGMA</a></li>
168 <li><a href='lang_reindex.html'>REINDEX</a></li>
169 <li><a href='lang_savepoint.html'>RELEASE SAVEPOINT</a></li>
170 <li><a href='lang_replace.html'>REPLACE</a></li>
171 <li><a href='lang_returning.html'>RETURNING clause</a></li>
172 <li><a href='lang_transaction.html'>ROLLBACK TRANSACTION</a></li>
173 <li><a href='lang_savepoint.html'>SAVEPOINT</a></li>
174 <li><a href='lang_select.html'>SELECT</a></li>
175 <li><a href='lang_update.html'>UPDATE</a></li>
176 <li><a href='lang_upsert.html'>UPSERT</a></li>
177 <li><a href='lang_vacuum.html'>VACUUM</a></li>
178 <li><a href='windowfunctions.html'>window functions</a></li>
179 <li><a href='lang_with.html'>WITH clause</a></li>
180 </ul>
181 </div>
182
183 </ul></td></tr></table>
184
185 <p>The routines <a href="c3ref/prepare.html">sqlite3_prepare_v2()</a>, <a href="c3ref/prepare.html">sqlite3_prepare()</a>,
186 <a href="c3ref/prepare.html">sqlite3_prepare16()</a>, <a href="c3ref/prepare.html">sqlite3_prepare16_v2()</a>,
187 <a href="c3ref/exec.html">sqlite3_exec()</a>, and <a href="c3ref/free_table.html">sqlite3_get_table()</a> accept
188 an SQL statement list (sql-stmt-list) which is a semicolon-separated
189 list of statements.</p>
190
191 <p><b><a href="syntax/sql-stmt-list.html">sql-stmt-list:</a></b></p><div class='imgcontainer'>
192 <div style="max-width:242px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 242.093 88.776" data-pikchr-date="20250319161943">
193 <circle cx="5.76" cy="55.08" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
194 <path d="M9.36,55.08L45.36,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
195 <polygon points="81.36,55.08 69.84,59.4 69.84,50.76" style="fill:rgb(0,0,0)"/>
196 <path d="M45.36,55.08L75.6,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
197 <path d="M81.36,70.2L160.733,70.2L160.733,39.96L81.36,39.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
198 <text x="121.046" y="55.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">sql-stmt</text>
199 <path d="M160.733,55.08L196.733,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
200 <polygon points="232.733,55.08 221.213,59.4 221.213,50.76" style="fill:rgb(0,0,0)"/>
201 <path d="M196.733,55.08L226.973,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
202 <circle cx="236.333" cy="55.08" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
203 <polygon points="121.046,82.296 109.526,86.616 109.526,77.976" style="fill:rgb(0,0,0)"/>
204 <path d="M45.36,55.08 L 52.86,55.08 Q 60.36,55.08 60.36,68.688 Q 60.36,82.296 75.36,82.296 L 100.286,82.296 L 115.286,82.296" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
205 <path d="M121.046,82.296 L 155.213,82.296 Q 170.213,82.296 170.213,68.688 Q 170.213,55.08 177.713,55.08 L 185.213,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
206 <path d="M121.046,32.4A15.12 15.12 0 0 0 136.166 17.28L136.166,17.28A15.12 15.12 0 0 0 121.046 2.16A15.12 15.12 0 0 0 105.926 17.28L105.926,17.28A15.12 15.12 0 0 0 121.046 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
207 <text x="121.046" y="17.28" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">;</text>
208 <polygon points="136.166,17.28 147.686,12.96 147.686,21.6" style="fill:rgb(0,0,0)"/>
209 <path d="M196.733,55.08 L 204.233,55.08 Q 211.733,55.08 211.733,40.08 L 211.733,32.28 Q 211.733,17.28 196.733,17.28 L 156.926,17.28 L 141.926,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
210 <path d="M105.926,17.28 L 33.84,17.28 Q 18.84,17.28 18.84,32.28 L 18.84,40.08 Q 18.84,55.08 26.34,55.08 L 33.84,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
211 </svg>
212 </div>
213 </div>
214
215
216 <p>Each SQL statement in the statement list is an instance of the
217 following:</p>
218
219 <p><b><a href="syntax/sql-stmt.html">sql-stmt:</a></b></p><div class='imgcontainer'>
220 <div style="max-width:716px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 716.88 1017.36" data-pikchr-date="20250319161943">
221 <circle cx="5.76" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
222 <polygon points="50.88,55.08 39.36,59.4 39.36,50.76" style="fill:rgb(0,0,0)"/>
223 <path d="M9.36,17.28 L 16.86,17.28 Q 24.36,17.28 24.36,32.28 L 24.36,40.08 Q 24.36,55.08 34.74,55.08 L 45.12,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
224 <path d="M66,70.2L125.616,70.2A15.12 15.12 0 0 0 140.736 55.08L140.736,55.08A15.12 15.12 0 0 0 125.616 39.96L66,39.96A15.12 15.12 0 0 0 50.88 55.08L50.88,55.08A15.12 15.12 0 0 0 66 70.2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
225 <text x="95.808" y="55.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXPLAIN</text>
226 <polygon points="176.736,55.08 165.216,59.4 165.216,50.76" style="fill:rgb(0,0,0)"/>
227 <path d="M140.736,55.08L170.976,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
228 <path d="M191.856,70.2L235.114,70.2A15.12 15.12 0 0 0 250.234 55.08L250.234,55.08A15.12 15.12 0 0 0 235.114 39.96L191.856,39.96A15.12 15.12 0 0 0 176.736 55.08L176.736,55.08A15.12 15.12 0 0 0 191.856 70.2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
229 <text x="213.485" y="55.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">QUERY</text>
230 <polygon points="267.514,55.08 255.994,59.4 255.994,50.76" style="fill:rgb(0,0,0)"/>
231 <path d="M250.234,55.08L261.754,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
232 <path d="M282.634,70.2L311.952,70.2A15.12 15.12 0 0 0 327.072 55.08L327.072,55.08A15.12 15.12 0 0 0 311.952 39.96L282.634,39.96A15.12 15.12 0 0 0 267.514 55.08L267.514,55.08A15.12 15.12 0 0 0 282.634 70.2Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
233 <text x="297.293" y="55.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">PLAN</text>
234 <polygon points="368.592,17.28 357.072,21.6 357.072,12.96" style="fill:rgb(0,0,0)"/>
235 <path d="M327.072,55.08 L 334.572,55.08 Q 342.072,55.08 342.072,40.08 L 342.072,32.28 Q 342.072,17.28 352.452,17.28 L 362.832,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
236 <polygon points="182.256,17.28 170.736,21.6 170.736,12.96" style="fill:rgb(0,0,0)"/>
237 <path d="M140.736,55.08 L 148.236,55.08 Q 155.736,55.08 155.736,40.08 L 155.736,32.28 Q 155.736,17.28 166.116,17.28 L 176.496,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
238 <path d="M182.256,17.28L357.072,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
239 <path d="M9.36,17.28L170.736,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
240 <polygon points="410.112,17.28 398.592,21.6 398.592,12.96" style="fill:rgb(0,0,0)"/>
241 <path d="M368.592,17.28L404.352,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
242 <path d="M410.112,32.4L552.614,32.4L552.614,2.16L410.112,2.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
243 <text x="481.363" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">alter-table-stmt</text>
244 <polygon points="666,17.28 654.48,21.6 654.48,12.96" style="fill:rgb(0,0,0)"/>
245 <path d="M552.614,17.28L660.24,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
246 <polygon points="707.52,17.28 696,21.6 696,12.96" style="fill:rgb(0,0,0)"/>
247 <path d="M666,17.28L701.76,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
248 <circle cx="711.12" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
249 <path d="M410.112,70.2L528.422,70.2L528.422,39.96L410.112,39.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
250 <text x="469.267" y="55.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">analyze-stmt</text>
251 <polygon points="410.112,55.08 398.592,59.4 398.592,50.76" style="fill:rgb(0,0,0)"/>
252 <path d="M383.592,39.96 L 383.592,47.52 Q 383.592,55.08 393.972,55.08 L 404.352,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
253 <polygon points="666,55.08 654.48,59.4 654.48,50.76" style="fill:rgb(0,0,0)"/>
254 <path d="M528.422,55.08L660.24,55.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
255 <path d="M666,55.08 L 673.5,55.08 Q 681,55.08 681,47.58 L 681,40.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
256 <path d="M410.112,108L517.709,108L517.709,77.76L410.112,77.76Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
257 <text x="463.91" y="92.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">attach-stmt</text>
258 <polygon points="410.112,92.88 398.592,97.2 398.592,88.56" style="fill:rgb(0,0,0)"/>
259 <path d="M383.592,77.76 L 383.592,85.32 Q 383.592,92.88 393.972,92.88 L 404.352,92.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
260 <polygon points="666,92.88 654.48,97.2 654.48,88.56" style="fill:rgb(0,0,0)"/>
261 <path d="M517.709,92.88L660.24,92.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
262 <path d="M666,92.88 L 673.5,92.88 Q 681,92.88 681,85.38 L 681,77.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
263 <path d="M410.112,145.8L511.718,145.8L511.718,115.56L410.112,115.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
264 <text x="460.915" y="130.68" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">begin-stmt</text>
265 <polygon points="410.112,130.68 398.592,135 398.592,126.36" style="fill:rgb(0,0,0)"/>
266 <path d="M383.592,115.56 L 383.592,123.12 Q 383.592,130.68 393.972,130.68 L 404.352,130.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
267 <polygon points="666,130.68 654.48,135 654.48,126.36" style="fill:rgb(0,0,0)"/>
268 <path d="M511.718,130.68L660.24,130.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
269 <path d="M666,130.68 L 673.5,130.68 Q 681,130.68 681,123.18 L 681,115.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
270 <path d="M410.112,183.6L527.04,183.6L527.04,153.36L410.112,153.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
271 <text x="468.576" y="168.48" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">commit-stmt</text>
272 <polygon points="410.112,168.48 398.592,172.8 398.592,164.16" style="fill:rgb(0,0,0)"/>
273 <path d="M383.592,153.36 L 383.592,160.92 Q 383.592,168.48 393.972,168.48 L 404.352,168.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
274 <polygon points="666,168.48 654.48,172.8 654.48,164.16" style="fill:rgb(0,0,0)"/>
275 <path d="M527.04,168.48L660.24,168.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
276 <path d="M666,168.48 L 673.5,168.48 Q 681,168.48 681,160.98 L 681,153.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
277 <path d="M410.112,221.4L569.318,221.4L569.318,191.16L410.112,191.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
278 <text x="489.715" y="206.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">create-index-stmt</text>
279 <polygon points="410.112,206.28 398.592,210.6 398.592,201.96" style="fill:rgb(0,0,0)"/>
280 <path d="M383.592,191.16 L 383.592,198.72 Q 383.592,206.28 393.972,206.28 L 404.352,206.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
281 <polygon points="666,206.28 654.48,210.6 654.48,201.96" style="fill:rgb(0,0,0)"/>
282 <path d="M569.318,206.28L660.24,206.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
283 <path d="M666,206.28 L 673.5,206.28 Q 681,206.28 681,198.78 L 681,191.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
284 <path d="M410.112,259.2L566.093,259.2L566.093,228.96L410.112,228.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
285 <text x="488.102" y="244.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">create-table-stmt</text>
286 <polygon points="410.112,244.08 398.592,248.4 398.592,239.76" style="fill:rgb(0,0,0)"/>
287 <path d="M383.592,228.96 L 383.592,236.52 Q 383.592,244.08 393.972,244.08 L 404.352,244.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
288 <polygon points="666,244.08 654.48,248.4 654.48,239.76" style="fill:rgb(0,0,0)"/>
289 <path d="M566.093,244.08L660.24,244.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
290 <path d="M666,244.08 L 673.5,244.08 Q 681,244.08 681,236.58 L 681,229.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
291 <path d="M410.112,297L582.566,297L582.566,266.76L410.112,266.76Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
292 <text x="496.339" y="281.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">create-trigger-stmt</text>
293 <polygon points="410.112,281.88 398.592,286.2 398.592,277.56" style="fill:rgb(0,0,0)"/>
294 <path d="M383.592,266.76 L 383.592,274.32 Q 383.592,281.88 393.972,281.88 L 404.352,281.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
295 <polygon points="666,281.88 654.48,286.2 654.48,277.56" style="fill:rgb(0,0,0)"/>
296 <path d="M582.566,281.88L660.24,281.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
297 <path d="M666,281.88 L 673.5,281.88 Q 681,281.88 681,274.38 L 681,266.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
298 <path d="M410.112,334.8L561.946,334.8L561.946,304.56L410.112,304.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
299 <text x="486.029" y="319.68" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">create-view-stmt</text>
300 <polygon points="410.112,319.68 398.592,324 398.592,315.36" style="fill:rgb(0,0,0)"/>
301 <path d="M383.592,304.56 L 383.592,312.12 Q 383.592,319.68 393.972,319.68 L 404.352,319.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
302 <polygon points="666,319.68 654.48,324 654.48,315.36" style="fill:rgb(0,0,0)"/>
303 <path d="M561.946,319.68L660.24,319.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
304 <path d="M666,319.68 L 673.5,319.68 Q 681,319.68 681,312.18 L 681,304.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
305 <path d="M410.112,372.6L626.918,372.6L626.918,342.36L410.112,342.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
306 <text x="518.515" y="357.48" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">create-virtual-table-stmt</text>
307 <polygon points="410.112,357.48 398.592,361.8 398.592,353.16" style="fill:rgb(0,0,0)"/>
308 <path d="M383.592,342.36 L 383.592,349.92 Q 383.592,357.48 393.972,357.48 L 404.352,357.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
309 <polygon points="666,357.48 654.48,361.8 654.48,353.16" style="fill:rgb(0,0,0)"/>
310 <path d="M626.918,357.48L660.24,357.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
311 <path d="M666,357.48 L 673.5,357.48 Q 681,357.48 681,349.98 L 681,342.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
312 <path d="M410.112,410.4L516.902,410.4L516.902,380.16L410.112,380.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
313 <text x="463.507" y="395.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">delete-stmt</text>
314 <polygon points="410.112,395.28 398.592,399.6 398.592,390.96" style="fill:rgb(0,0,0)"/>
315 <path d="M383.592,380.16 L 383.592,387.72 Q 383.592,395.28 393.972,395.28 L 404.352,395.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
316 <polygon points="666,395.28 654.48,399.6 654.48,390.96" style="fill:rgb(0,0,0)"/>
317 <path d="M516.902,395.28L660.24,395.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
318 <path d="M666,395.28 L 673.5,395.28 Q 681,395.28 681,387.78 L 681,380.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
319 <path d="M410.112,448.2L581.414,448.2L581.414,417.96L410.112,417.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
320 <text x="495.763" y="433.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">delete-stmt-limited</text>
321 <polygon points="410.112,433.08 398.592,437.4 398.592,428.76" style="fill:rgb(0,0,0)"/>
322 <path d="M383.592,417.96 L 383.592,425.52 Q 383.592,433.08 393.972,433.08 L 404.352,433.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
323 <polygon points="666,433.08 654.48,437.4 654.48,428.76" style="fill:rgb(0,0,0)"/>
324 <path d="M581.414,433.08L660.24,433.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
325 <path d="M666,433.08 L 673.5,433.08 Q 681,433.08 681,425.58 L 681,418.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
326 <path d="M410.112,486L521.51,486L521.51,455.76L410.112,455.76Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
327 <text x="465.811" y="470.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">detach-stmt</text>
328 <polygon points="410.112,470.88 398.592,475.2 398.592,466.56" style="fill:rgb(0,0,0)"/>
329 <path d="M383.592,455.76 L 383.592,463.32 Q 383.592,470.88 393.972,470.88 L 404.352,470.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
330 <polygon points="666,470.88 654.48,475.2 654.48,466.56" style="fill:rgb(0,0,0)"/>
331 <path d="M521.51,470.88L660.24,470.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
332 <path d="M666,470.88 L 673.5,470.88 Q 681,470.88 681,463.38 L 681,455.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
333 <path d="M410.112,523.8L555.034,523.8L555.034,493.56L410.112,493.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
334 <text x="482.573" y="508.68" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">drop-index-stmt</text>
335 <polygon points="410.112,508.68 398.592,513 398.592,504.36" style="fill:rgb(0,0,0)"/>
336 <path d="M383.592,493.56 L 383.592,501.12 Q 383.592,508.68 393.972,508.68 L 404.352,508.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
337 <polygon points="666,508.68 654.48,513 654.48,504.36" style="fill:rgb(0,0,0)"/>
338 <path d="M555.034,508.68L660.24,508.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
339 <path d="M666,508.68 L 673.5,508.68 Q 681,508.68 681,501.18 L 681,493.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
340 <path d="M410.112,561.6L551.808,561.6L551.808,531.36L410.112,531.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
341 <text x="480.96" y="546.48" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">drop-table-stmt</text>
342 <polygon points="410.112,546.48 398.592,550.8 398.592,542.16" style="fill:rgb(0,0,0)"/>
343 <path d="M383.592,531.36 L 383.592,538.92 Q 383.592,546.48 393.972,546.48 L 404.352,546.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
344 <polygon points="666,546.48 654.48,550.8 654.48,542.16" style="fill:rgb(0,0,0)"/>
345 <path d="M551.808,546.48L660.24,546.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
346 <path d="M666,546.48 L 673.5,546.48 Q 681,546.48 681,538.98 L 681,531.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
347 <path d="M410.112,599.4L568.282,599.4L568.282,569.16L410.112,569.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
348 <text x="489.197" y="584.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">drop-trigger-stmt</text>
349 <polygon points="410.112,584.28 398.592,588.6 398.592,579.96" style="fill:rgb(0,0,0)"/>
350 <path d="M383.592,569.16 L 383.592,576.72 Q 383.592,584.28 393.972,584.28 L 404.352,584.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
351 <polygon points="666,584.28 654.48,588.6 654.48,579.96" style="fill:rgb(0,0,0)"/>
352 <path d="M568.282,584.28L660.24,584.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
353 <path d="M666,584.28 L 673.5,584.28 Q 681,584.28 681,576.78 L 681,569.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
354 <path d="M410.112,637.2L547.661,637.2L547.661,606.96L410.112,606.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
355 <text x="478.886" y="622.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">drop-view-stmt</text>
356 <polygon points="410.112,622.08 398.592,626.4 398.592,617.76" style="fill:rgb(0,0,0)"/>
357 <path d="M383.592,606.96 L 383.592,614.52 Q 383.592,622.08 393.972,622.08 L 404.352,622.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
358 <polygon points="666,622.08 654.48,626.4 654.48,617.76" style="fill:rgb(0,0,0)"/>
359 <path d="M547.661,622.08L660.24,622.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
360 <path d="M666,622.08 L 673.5,622.08 Q 681,622.08 681,614.58 L 681,607.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
361 <path d="M410.112,675L513.792,675L513.792,644.76L410.112,644.76Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
362 <text x="461.952" y="659.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">insert-stmt</text>
363 <polygon points="410.112,659.88 398.592,664.2 398.592,655.56" style="fill:rgb(0,0,0)"/>
364 <path d="M383.592,644.76 L 383.592,652.32 Q 383.592,659.88 393.972,659.88 L 404.352,659.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
365 <polygon points="666,659.88 654.48,664.2 654.48,655.56" style="fill:rgb(0,0,0)"/>
366 <path d="M513.792,659.88L660.24,659.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
367 <path d="M666,659.88 L 673.5,659.88 Q 681,659.88 681,652.38 L 681,644.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
368 <path d="M410.112,712.8L529.229,712.8L529.229,682.56L410.112,682.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
369 <text x="469.67" y="697.68" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">pragma-stmt</text>
370 <polygon points="410.112,697.68 398.592,702 398.592,693.36" style="fill:rgb(0,0,0)"/>
371 <path d="M383.592,682.56 L 383.592,690.12 Q 383.592,697.68 393.972,697.68 L 404.352,697.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
372 <polygon points="666,697.68 654.48,702 654.48,693.36" style="fill:rgb(0,0,0)"/>
373 <path d="M529.229,697.68L660.24,697.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
374 <path d="M666,697.68 L 673.5,697.68 Q 681,697.68 681,690.18 L 681,682.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
375 <path d="M410.112,750.6L528.192,750.6L528.192,720.36L410.112,720.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
376 <text x="469.152" y="735.48" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">reindex-stmt</text>
377 <polygon points="410.112,735.48 398.592,739.8 398.592,731.16" style="fill:rgb(0,0,0)"/>
378 <path d="M383.592,720.36 L 383.592,727.92 Q 383.592,735.48 393.972,735.48 L 404.352,735.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
379 <polygon points="666,735.48 654.48,739.8 654.48,731.16" style="fill:rgb(0,0,0)"/>
380 <path d="M528.192,735.48L660.24,735.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
381 <path d="M666,735.48 L 673.5,735.48 Q 681,735.48 681,727.98 L 681,720.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
382 <path d="M410.112,788.4L526.118,788.4L526.118,758.16L410.112,758.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
383 <text x="468.115" y="773.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">release-stmt</text>
384 <polygon points="410.112,773.28 398.592,777.6 398.592,768.96" style="fill:rgb(0,0,0)"/>
385 <path d="M383.592,758.16 L 383.592,765.72 Q 383.592,773.28 393.972,773.28 L 404.352,773.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
386 <polygon points="666,773.28 654.48,777.6 654.48,768.96" style="fill:rgb(0,0,0)"/>
387 <path d="M526.118,773.28L660.24,773.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
388 <path d="M666,773.28 L 673.5,773.28 Q 681,773.28 681,765.78 L 681,758.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
389 <path d="M410.112,826.2L533.491,826.2L533.491,795.96L410.112,795.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
390 <text x="471.802" y="811.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">rollback-stmt</text>
391 <polygon points="410.112,811.08 398.592,815.4 398.592,806.76" style="fill:rgb(0,0,0)"/>
392 <path d="M383.592,795.96 L 383.592,803.52 Q 383.592,811.08 393.972,811.08 L 404.352,811.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
393 <polygon points="666,811.08 654.48,815.4 654.48,806.76" style="fill:rgb(0,0,0)"/>
394 <path d="M533.491,811.08L660.24,811.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
395 <path d="M666,811.08 L 673.5,811.08 Q 681,811.08 681,803.58 L 681,796.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
396 <path d="M410.112,864L545.472,864L545.472,833.76L410.112,833.76Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
397 <text x="477.792" y="848.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">savepoint-stmt</text>
398 <polygon points="410.112,848.88 398.592,853.2 398.592,844.56" style="fill:rgb(0,0,0)"/>
399 <path d="M383.592,833.76 L 383.592,841.32 Q 383.592,848.88 393.972,848.88 L 404.352,848.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
400 <polygon points="666,848.88 654.48,853.2 654.48,844.56" style="fill:rgb(0,0,0)"/>
401 <path d="M545.472,848.88L660.24,848.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
402 <path d="M666,848.88 L 673.5,848.88 Q 681,848.88 681,841.38 L 681,833.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
403 <path d="M410.112,901.8L514.368,901.8L514.368,871.56L410.112,871.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
404 <text x="462.24" y="886.68" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">select-stmt</text>
405 <polygon points="410.112,886.68 398.592,891 398.592,882.36" style="fill:rgb(0,0,0)"/>
406 <path d="M383.592,871.56 L 383.592,879.12 Q 383.592,886.68 393.972,886.68 L 404.352,886.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
407 <polygon points="666,886.68 654.48,891 654.48,882.36" style="fill:rgb(0,0,0)"/>
408 <path d="M514.368,886.68L660.24,886.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
409 <path d="M666,886.68 L 673.5,886.68 Q 681,886.68 681,879.18 L 681,871.68" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
410 <path d="M410.112,939.6L522.893,939.6L522.893,909.36L410.112,909.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
411 <text x="466.502" y="924.48" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">update-stmt</text>
412 <polygon points="410.112,924.48 398.592,928.8 398.592,920.16" style="fill:rgb(0,0,0)"/>
413 <path d="M383.592,909.36 L 383.592,916.92 Q 383.592,924.48 393.972,924.48 L 404.352,924.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
414 <polygon points="666,924.48 654.48,928.8 654.48,920.16" style="fill:rgb(0,0,0)"/>
415 <path d="M522.893,924.48L660.24,924.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
416 <path d="M666,924.48 L 673.5,924.48 Q 681,924.48 681,916.98 L 681,909.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
417 <path d="M410.112,977.4L587.405,977.4L587.405,947.16L410.112,947.16Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
418 <text x="498.758" y="962.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">update-stmt-limited</text>
419 <polygon points="410.112,962.28 398.592,966.6 398.592,957.96" style="fill:rgb(0,0,0)"/>
420 <path d="M383.592,947.16 L 383.592,954.72 Q 383.592,962.28 393.972,962.28 L 404.352,962.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
421 <polygon points="666,962.28 654.48,966.6 654.48,957.96" style="fill:rgb(0,0,0)"/>
422 <path d="M587.405,962.28L660.24,962.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
423 <path d="M666,962.28 L 673.5,962.28 Q 681,962.28 681,954.78 L 681,947.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
424 <path d="M410.112,1015.2L529.805,1015.2L529.805,984.96L410.112,984.96Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
425 <text x="469.958" y="1000.08" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">vacuum-stmt</text>
426 <polygon points="410.112,1000.08 398.592,1004.4 398.592,995.76" style="fill:rgb(0,0,0)"/>
427 <path d="M368.592,17.28 L 376.092,17.28 Q 383.592,17.28 383.592,32.28 L 383.592,985.08 Q 383.592,1000.08 393.972,1000.08 L 404.352,1000.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
428 <polygon points="666,1000.08 654.48,1004.4 654.48,995.76" style="fill:rgb(0,0,0)"/>
429 <path d="M529.805,1000.08L660.24,1000.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
430 <path d="M666,1000.08 L 673.5,1000.08 Q 681,1000.08 681,985.08 L 681,32.28 Q 681,17.28 688.5,17.28 L 696,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
431 </svg>
432 </div>
433 </div>
434
435 <p align="center"><small><i>This page was last updated on 2024-04-01 12:41:31Z </small></i></p>
436