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
|
<!DOCTYPE html>
<html><head>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<link href="../sqlite.css" rel="stylesheet">
<title>SQLite Syntax: column-constraint</title>
<!-- path=../ -->
</head>
<body>
<div class=nosearch>
<a href="../index.html">
<img class="logo" src="../images/sqlite370_banner.gif" alt="SQLite" border="0">
</a>
<div><!-- IE hack to prevent disappearing logo --></div>
<div class="tagline desktoponly">
Small. Fast. Reliable.<br>Choose any three.
</div>
<div class="menu mainmenu">
<ul>
<li><a href="../index.html">Home</a>
<li class='mobileonly'><a href="javascript:void(0)" onclick='toggle_div("submenu")'>Menu</a>
<li class='wideonly'><a href='../about.html'>About</a>
<li class='desktoponly'><a href="../docs.html">Documentation</a>
<li class='desktoponly'><a href="../download.html">Download</a>
<li class='wideonly'><a href='../copyright.html'>License</a>
<li class='desktoponly'><a href="../support.html">Support</a>
<li class='desktoponly'><a href="../prosupport.html">Purchase</a>
<li class='search' id='search_menubutton'>
<a href="javascript:void(0)" onclick='toggle_search()'>Search</a>
</ul>
</div>
<div class="menu submenu" id="submenu">
<ul>
<li><a href='../about.html'>About</a>
<li><a href='../docs.html'>Documentation</a>
<li><a href='../download.html'>Download</a>
<li><a href='../support.html'>Support</a>
<li><a href='../prosupport.html'>Purchase</a>
</ul>
</div>
<div class="searchmenu" id="searchmenu">
<form method="GET" action="../search">
<select name="s" id="searchtype">
<option value="d">Search Documentation</option>
<option value="c">Search Changelog</option>
</select>
<input type="text" name="q" id="searchbox" value="">
<input type="submit" value="Go">
</form>
</div>
</div>
<script>
function toggle_div(nm) {
var w = document.getElementById(nm);
if( w.style.display=="block" ){
w.style.display = "none";
}else{
w.style.display = "block";
}
}
function toggle_search() {
var w = document.getElementById("searchmenu");
if( w.style.display=="block" ){
w.style.display = "none";
} else {
w.style.display = "block";
setTimeout(function(){
document.getElementById("searchbox").focus()
}, 30);
}
}
function div_off(nm){document.getElementById(nm).style.display="none";}
window.onbeforeunload = function(e){div_off("submenu");}
/* Disable the Search feature if we are not operating from CGI, since */
/* Search is accomplished using CGI and will not work without it. */
if( !location.origin || !location.origin.match || !location.origin.match(/http/) ){
document.getElementById("search_menubutton").style.display = "none";
}
/* Used by the Hide/Show button beside syntax diagrams, to toggle the */
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;
}
var antiRobot = 0;
function antiRobotGo(){
if( antiRobot!=3 ) return;
antiRobot = 7;
var j = document.getElementById("mtimelink");
if(j && j.hasAttribute("data-href")) j.href=j.getAttribute("data-href");
}
function antiRobotDefense(){
document.body.onmousedown=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousedown=null;
}
document.body.onmousemove=function(){
antiRobot |= 2;
antiRobotGo();
document.body.onmousemove=null;
}
setTimeout(function(){
antiRobot |= 1;
antiRobotGo();
}, 100)
antiRobotGo();
}
antiRobotDefense();
</script>
<h1 align='center'>column-constraint</h1>
<div class='imgcontainer'>
<div style="max-width:844px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 844.306 578.88">
<circle cx="5" cy="17" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
<path d="M9,17L26,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="47,40 43,28 51,28" style="fill:rgb(0,0,0)"/>
<path d="M32,17 L 39,17 Q 47,17 47,25 L 47,34" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="68,17 56,21 56,12" style="fill:rgb(0,0,0)"/>
<path d="M32,17L62,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M83,32L183,32A15 15 0 0 0 198 17A15 15 0 0 0 183 2L83,2A15 15 0 0 0 68 17A15 15 0 0 0 83 32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="133" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CONSTRAINT</text>
<polygon points="221,17 210,21 210,12" style="fill:rgb(0,0,0)"/>
<path d="M198,17L215,17" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M236,32L263,32A15 15 0 0 0 279 17A15 15 0 0 0 263 2L236,2A15 15 0 0 0 221 17A15 15 0 0 0 236 32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="250" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">name</text>
<polygon points="173,47 185,43 185,51" style="fill:rgb(0,0,0)"/>
<path d="M279,17 L 300,17 Q 315,17 315,32 L 315,32 Q 315,47 300,47 L 194,47 L 179,47" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M173,47 L 62,47 Q 47,47 47,55 L 47,62" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,77 58,82 58,73" style="fill:rgb(0,0,0)"/>
<path d="M47,40 L 47,62 Q 47,77 56,77 L 64,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,92L148,92A15 15 0 0 0 163 77A15 15 0 0 0 148 62L85,62A15 15 0 0 0 70 77A15 15 0 0 0 85 92Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="116" y="77" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">PRIMARY</text>
<polygon points="186,77 174,82 174,73" style="fill:rgb(0,0,0)"/>
<path d="M163,77L180,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M201,92L217,92A15 15 0 0 0 233 77A15 15 0 0 0 217 62L201,62A15 15 0 0 0 186 77A15 15 0 0 0 201 92Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="209" y="77" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">KEY</text>
<polygon points="271,138 259,142 259,133" style="fill:rgb(0,0,0)"/>
<path d="M233,77 L 240,77 Q 248,77 248,92 L 248,123 Q 248,138 256,138 L 265,138" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M286,153L316,153A15 15 0 0 0 331 138A15 15 0 0 0 316 123L286,123A15 15 0 0 0 271 138A15 15 0 0 0 286 153Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="301" y="138" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DESC</text>
<polygon points="354,138 343,142 343,133" style="fill:rgb(0,0,0)"/>
<path d="M331,138L348,138" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="392,77 381,82 381,73" style="fill:rgb(0,0,0)"/>
<path d="M354,138 L 362,138 Q 369,138 369,123 L 369,92 Q 369,77 378,77 L 386,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M392,92L525,92L525,62L392,62Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="459" y="77" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text>
<polygon points="549,77 537,82 537,73" style="fill:rgb(0,0,0)"/>
<path d="M525,77L543,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="587,108 575,112 575,103" style="fill:rgb(0,0,0)"/>
<path d="M549,77 L 556,77 Q 564,77 564,92 L 564,93 Q 564,108 572,108 L 581,108" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M602,123L745,123A15 15 0 0 0 760 108A15 15 0 0 0 745 92L602,92A15 15 0 0 0 587 108A15 15 0 0 0 602 123Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="673" y="108" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AUTOINCREMENT</text>
<polygon points="783,108 772,112 772,103" style="fill:rgb(0,0,0)"/>
<path d="M760,108L778,108" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="834,77 823,82 823,73" style="fill:rgb(0,0,0)"/>
<path d="M783,108 L 791,108 Q 798,108 798,93 L 798,92 Q 798,77 813,77 L 814,77 L 829,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<circle cx="838" cy="77" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="673,77 662,82 662,73" style="fill:rgb(0,0,0)"/>
<path d="M549,77L668,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M673,77L827,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="301,77 289,82 289,73" style="fill:rgb(0,0,0)"/>
<path d="M233,77L295,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M301,77L381,77" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="271,100 259,104 259,96" style="fill:rgb(0,0,0)"/>
<path d="M233,77 L 240,77 Q 248,77 248,89 Q 248,100 256,100 L 265,100" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M286,115L302,115A15 15 0 0 0 318 100A15 15 0 0 0 302 85L286,85A15 15 0 0 0 271 100A15 15 0 0 0 286 115Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="294" y="100" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ASC</text>
<polygon points="354,100 343,104 343,96" style="fill:rgb(0,0,0)"/>
<path d="M318,100L348,100" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M354,100 L 362,100 Q 369,100 369,92 L 369,85" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,183 58,187 58,179" style="fill:rgb(0,0,0)"/>
<path d="M47,62 L 47,168 Q 47,183 56,183 L 64,183" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,198L105,198A15 15 0 0 0 120 183A15 15 0 0 0 105 168L85,168A15 15 0 0 0 70 183A15 15 0 0 0 85 198Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="95" y="183" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text>
<polygon points="143,183 132,187 132,179" style="fill:rgb(0,0,0)"/>
<path d="M120,183L138,183" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M158,198L190,198A15 15 0 0 0 205 183A15 15 0 0 0 190 168L158,168A15 15 0 0 0 143 183A15 15 0 0 0 158 198Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="174" y="183" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NULL</text>
<polygon points="228,183 216,187 216,179" style="fill:rgb(0,0,0)"/>
<path d="M205,183L222,183" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M228,198L361,198L361,168L228,168Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="294" y="183" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text>
<polygon points="783,183 772,187 772,179" style="fill:rgb(0,0,0)"/>
<path d="M361,183L778,183" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,183 L 791,183 Q 798,183 798,168 L 798,107 L 798,92" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,221 58,225 58,217" style="fill:rgb(0,0,0)"/>
<path d="M47,168 L 47,206 Q 47,221 56,221 L 64,221" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,236L140,236A15 15 0 0 0 155 221A15 15 0 0 0 140 206L85,206A15 15 0 0 0 70 221A15 15 0 0 0 85 236Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="113" y="221" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UNIQUE</text>
<polygon points="178,221 167,225 167,217" style="fill:rgb(0,0,0)"/>
<path d="M155,221L172,221" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M178,236L311,236L311,206L178,206Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="245" y="221" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text>
<polygon points="783,221 772,225 772,217" style="fill:rgb(0,0,0)"/>
<path d="M311,221L778,221" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,221 L 791,221 Q 798,221 798,206 L 798,183 L 798,168" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,259 58,263 58,254" style="fill:rgb(0,0,0)"/>
<path d="M47,206 L 47,244 Q 47,259 56,259 L 64,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,274L131,274A15 15 0 0 0 146 259A15 15 0 0 0 131 244L85,244A15 15 0 0 0 70 259A15 15 0 0 0 85 274Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="108" y="259" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CHECK</text>
<polygon points="169,259 157,263 157,254" style="fill:rgb(0,0,0)"/>
<path d="M146,259L163,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M184,274A15 15 0 0 0 199 259A15 15 0 0 0 184 244A15 15 0 0 0 169 259A15 15 0 0 0 184 274Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="184" y="259" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="222,259 210,263 210,254" style="fill:rgb(0,0,0)"/>
<path d="M199,259L216,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M222,274L271,274L271,244L222,244Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="247" y="259" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="294,259 283,263 283,254" style="fill:rgb(0,0,0)"/>
<path d="M271,259L288,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M309,274A15 15 0 0 0 324 259A15 15 0 0 0 309 244A15 15 0 0 0 294 259A15 15 0 0 0 309 274Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="309" y="259" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="783,259 772,263 772,254" style="fill:rgb(0,0,0)"/>
<path d="M324,259L778,259" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,259 L 791,259 Q 798,259 798,244 L 798,221 L 798,206" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,297 58,301 58,292" style="fill:rgb(0,0,0)"/>
<path d="M47,244 L 47,282 Q 47,297 56,297 L 64,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,312L150,312A15 15 0 0 0 166 297A15 15 0 0 0 150 281L85,281A15 15 0 0 0 70 297A15 15 0 0 0 85 312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="118" y="297" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DEFAULT</text>
<polygon points="189,297 177,301 177,292" style="fill:rgb(0,0,0)"/>
<path d="M166,297L183,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="225,297 213,301 213,292" style="fill:rgb(0,0,0)"/>
<path d="M189,297L219,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M240,312A15 15 0 0 0 255 297A15 15 0 0 0 240 281A15 15 0 0 0 225 297A15 15 0 0 0 240 312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="240" y="297" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="278,297 266,301 266,292" style="fill:rgb(0,0,0)"/>
<path d="M255,297L272,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M278,312L327,312L327,281L278,281Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="302" y="297" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="350,297 339,301 339,292" style="fill:rgb(0,0,0)"/>
<path d="M327,297L344,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M365,312A15 15 0 0 0 380 297A15 15 0 0 0 365 281A15 15 0 0 0 350 297A15 15 0 0 0 365 312Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="365" y="297" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="783,297 772,301 772,292" style="fill:rgb(0,0,0)"/>
<path d="M380,297L778,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,297 L 791,297 Q 798,297 798,282 L 798,259 L 798,244" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="227,334 215,339 215,330" style="fill:rgb(0,0,0)"/>
<path d="M189,297 L 196,297 Q 204,297 204,312 L 204,319 Q 204,334 212,334 L 221,334" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M227,349L340,349L340,319L227,319Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="283" y="334" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">literal-value</text>
<polygon points="363,334 351,339 351,330" style="fill:rgb(0,0,0)"/>
<path d="M340,334L357,334" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M363,334 L 395,334 Q 410,334 410,319 L 410,312 Q 410,297 425,297 L 431,297 L 446,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="227,372 215,376 215,368" style="fill:rgb(0,0,0)"/>
<path d="M189,297 L 196,297 Q 204,297 204,312 L 204,357 Q 204,372 212,372 L 221,372" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M227,387L364,387L364,357L227,357Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="296" y="372" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">signed-number</text>
<polygon points="387,372 376,376 376,368" style="fill:rgb(0,0,0)"/>
<path d="M364,372L382,372" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M387,372 L 399,372 Q 410,372 410,357 L 410,312 Q 410,297 425,297 L 431,297 L 446,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,410 58,414 58,406" style="fill:rgb(0,0,0)"/>
<path d="M47,281 L 47,395 Q 47,410 56,410 L 64,410" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,425L149,425A15 15 0 0 0 164 410A15 15 0 0 0 149 395L85,395A15 15 0 0 0 70 410A15 15 0 0 0 85 425Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="117" y="410" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLLATE</text>
<polygon points="187,410 176,414 176,406" style="fill:rgb(0,0,0)"/>
<path d="M164,410L182,410" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M202,425L308,425A15 15 0 0 0 323 410A15 15 0 0 0 308 395L202,395A15 15 0 0 0 187 410A15 15 0 0 0 202 425Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="255" y="410" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">collation-name</text>
<polygon points="783,410 772,414 772,406" style="fill:rgb(0,0,0)"/>
<path d="M323,410L778,410" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,410 L 791,410 Q 798,410 798,395 L 798,296 L 798,281" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,448 58,452 58,443" style="fill:rgb(0,0,0)"/>
<path d="M47,395 L 47,433 Q 47,448 56,448 L 64,448" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M70,463L236,463L236,433L70,433Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="153" y="448" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">foreign-key-clause</text>
<polygon points="783,448 772,452 772,443" style="fill:rgb(0,0,0)"/>
<path d="M236,448L778,448" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,448 L 791,448 Q 798,448 798,433 L 798,410 L 798,395" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="70,486 58,490 58,481" style="fill:rgb(0,0,0)"/>
<path d="M47,433 L 47,471 Q 47,486 56,486 L 64,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M85,501L178,501A15 15 0 0 0 193 486A15 15 0 0 0 178 470L85,470A15 15 0 0 0 70 486A15 15 0 0 0 85 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="131" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">GENERATED</text>
<polygon points="216,486 204,490 204,481" style="fill:rgb(0,0,0)"/>
<path d="M193,486L210,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M231,501L286,501A15 15 0 0 0 301 486A15 15 0 0 0 286 470L231,470A15 15 0 0 0 216 486A15 15 0 0 0 231 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="258" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALWAYS</text>
<polygon points="337,486 325,490 325,481" style="fill:rgb(0,0,0)"/>
<path d="M301,486L331,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M352,501L356,501A15 15 0 0 0 371 486A15 15 0 0 0 356 470L352,470A15 15 0 0 0 337 486A15 15 0 0 0 352 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="354" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text>
<polygon points="394,486 382,490 382,481" style="fill:rgb(0,0,0)"/>
<path d="M371,486L388,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M409,501A15 15 0 0 0 424 486A15 15 0 0 0 409 470A15 15 0 0 0 394 486A15 15 0 0 0 409 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="409" y="486" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
<polygon points="447,486 436,490 436,481" style="fill:rgb(0,0,0)"/>
<path d="M424,486L441,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M447,501L496,501L496,470L447,470Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="472" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
<polygon points="519,486 508,490 508,481" style="fill:rgb(0,0,0)"/>
<path d="M496,486L514,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M535,501A15 15 0 0 0 550 486A15 15 0 0 0 535 470A15 15 0 0 0 519 486A15 15 0 0 0 535 501Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="535" y="486" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
<polygon points="783,486 772,490 772,481" style="fill:rgb(0,0,0)"/>
<path d="M550,486L778,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,486 L 791,486 Q 798,486 798,471 L 798,448 L 798,433" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="185,516 174,520 174,511" style="fill:rgb(0,0,0)"/>
<path d="M47,470 L 47,501 Q 47,516 62,516 L 165,516 L 180,516" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M185,516 L 297,516 Q 312,516 312,501 L 312,501 Q 312,486 320,486 L 327,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="596,561 584,565 584,557" style="fill:rgb(0,0,0)"/>
<path d="M550,486 L 561,486 Q 573,486 573,501 L 573,546 Q 573,561 581,561 L 590,561" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M611,576L670,576A15 15 0 0 0 686 561A15 15 0 0 0 670 546L611,546A15 15 0 0 0 596 561A15 15 0 0 0 611 576Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="641" y="561" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VIRTUAL</text>
<polygon points="783,561 772,565 772,557" style="fill:rgb(0,0,0)"/>
<path d="M686,561L778,561" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,561 L 791,561 Q 798,561 798,546 L 798,485 L 798,470" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<polygon points="596,523 584,528 584,519" style="fill:rgb(0,0,0)"/>
<path d="M550,486 L 561,486 Q 573,486 573,501 L 573,508 Q 573,523 581,523 L 590,523" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M611,538L665,538A15 15 0 0 0 680 523A15 15 0 0 0 665 508L611,508A15 15 0 0 0 596 523A15 15 0 0 0 611 538Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<text x="638" y="523" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">STORED</text>
<polygon points="783,523 772,528 772,519" style="fill:rgb(0,0,0)"/>
<path d="M680,523L778,523" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
<path d="M783,523 L 791,523 Q 798,523 798,516 L 798,508" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
</svg>
</div><br>
Used by: <a href='./column-def.html'>column-def</a><br></br>
References: <a href='./conflict-clause.html'>conflict-clause</a> <a href='./expr.html'>expr</a> <a href='./foreign-key-clause.html'>foreign-key-clause</a> <a href='./literal-value.html'>literal-value</a> <a href='./signed-number.html'>signed-number</a><br></br>
See also: <a href='../gencol.html'>gencol.html</a> <a href='../lang_altertable.html'>lang_altertable.html</a> <a href='../lang_createtable.html'>lang_createtable.html</a>
</div>
|
