| 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>SQLite Syntax: column-constraint</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 |
<h1 align='center'>column-constraint</h1> |
| 119 |
<div class='imgcontainer'> |
| 120 |
<div style="max-width:844px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 844.306 578.88" data-pikchr-date="20250319161943"> |
| 121 |
<circle cx="5.76" cy="17.28" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 122 |
<polygon points="32.4,17.28 20.88,21.6 20.88,12.96" style="fill:rgb(0,0,0)"/> |
| 123 |
<path d="M9.36,17.28L26.64,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 124 |
<polygon points="47.4,40.32 43.08,28.8 51.72,28.8" style="fill:rgb(0,0,0)"/> |
| 125 |
<path d="M32.4,17.28 L 39.9,17.28 Q 47.4,17.28 47.4,25.92 L 47.4,34.56" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 126 |
<polygon points="68.4,17.28 56.88,21.6 56.88,12.96" style="fill:rgb(0,0,0)"/> |
| 127 |
<path d="M32.4,17.28L62.64,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 128 |
<path d="M83.52,32.4L183.571,32.4A15.12 15.12 0 0 0 198.691 17.28A15.12 15.12 0 0 0 183.571 2.16L83.52,2.16A15.12 15.12 0 0 0 68.4 17.28A15.12 15.12 0 0 0 83.52 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 129 |
<text x="133.546" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CONSTRAINT</text> |
| 130 |
<polygon points="221.731,17.28 210.211,21.6 210.211,12.96" style="fill:rgb(0,0,0)"/> |
| 131 |
<path d="M198.691,17.28L215.971,17.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 132 |
<path d="M236.851,32.4L263.981,32.4A15.12 15.12 0 0 0 279.101 17.28A15.12 15.12 0 0 0 263.981 2.16L236.851,2.16A15.12 15.12 0 0 0 221.731 17.28A15.12 15.12 0 0 0 236.851 32.4Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 133 |
<text x="250.416" y="17.28" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">name</text> |
| 134 |
<polygon points="173.75,47.52 185.27,43.2 185.27,51.84" style="fill:rgb(0,0,0)"/> |
| 135 |
<path d="M279.101,17.28 L 300.101,17.28 Q 315.101,17.28 315.101,32.28 L 315.101,32.52 Q 315.101,47.52 300.101,47.52 L 194.51,47.52 L 179.51,47.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 136 |
<path d="M173.75,47.52 L 62.4,47.52 Q 47.4,47.52 47.4,55.02 L 47.4,62.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 137 |
<polygon points="70.44,77.76 58.92,82.08 58.92,73.44" style="fill:rgb(0,0,0)"/> |
| 138 |
<path d="M47.4,40.32 L 47.4,62.76 Q 47.4,77.76 56.04,77.76 L 64.68,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 139 |
<path d="M85.56,92.88L148.286,92.88A15.12 15.12 0 0 0 163.406 77.76A15.12 15.12 0 0 0 148.286 62.64L85.56,62.64A15.12 15.12 0 0 0 70.44 77.76A15.12 15.12 0 0 0 85.56 92.88Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 140 |
<text x="116.923" y="77.76" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">PRIMARY</text> |
| 141 |
<polygon points="186.446,77.76 174.926,82.08 174.926,73.44" style="fill:rgb(0,0,0)"/> |
| 142 |
<path d="M163.406,77.76L180.686,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 143 |
<path d="M201.566,92.88L217.982,92.88A15.12 15.12 0 0 0 233.102 77.76A15.12 15.12 0 0 0 217.982 62.64L201.566,62.64A15.12 15.12 0 0 0 186.446 77.76A15.12 15.12 0 0 0 201.566 92.88Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 144 |
<text x="209.774" y="77.76" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">KEY</text> |
| 145 |
<polygon points="271.142,138.24 259.622,142.56 259.622,133.92" style="fill:rgb(0,0,0)"/> |
| 146 |
<path d="M233.102,77.76 L 240.602,77.76 Q 248.102,77.76 248.102,92.76 L 248.102,123.24 Q 248.102,138.24 256.742,138.24 L 265.382,138.24" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 147 |
<path d="M286.262,153.36L316.502,153.36A15.12 15.12 0 0 0 331.622 138.24A15.12 15.12 0 0 0 316.502 123.12L286.262,123.12A15.12 15.12 0 0 0 271.142 138.24A15.12 15.12 0 0 0 286.262 153.36Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 148 |
<text x="301.382" y="138.24" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DESC</text> |
| 149 |
<polygon points="354.662,138.24 343.142,142.56 343.142,133.92" style="fill:rgb(0,0,0)"/> |
| 150 |
<path d="M331.622,138.24L348.902,138.24" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 151 |
<polygon points="392.702,77.76 381.182,82.08 381.182,73.44" style="fill:rgb(0,0,0)"/> |
| 152 |
<path d="M354.662,138.24 L 362.162,138.24 Q 369.662,138.24 369.662,123.24 L 369.662,92.76 Q 369.662,77.76 378.302,77.76 L 386.942,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 153 |
<path d="M392.702,92.88L525.989,92.88L525.989,62.64L392.702,62.64Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 154 |
<text x="459.346" y="77.76" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text> |
| 155 |
<polygon points="549.029,77.76 537.509,82.08 537.509,73.44" style="fill:rgb(0,0,0)"/> |
| 156 |
<path d="M525.989,77.76L543.269,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 157 |
<polygon points="587.069,108 575.549,112.32 575.549,103.68" style="fill:rgb(0,0,0)"/> |
| 158 |
<path d="M549.029,77.76 L 556.529,77.76 Q 564.029,77.76 564.029,92.76 L 564.029,93 Q 564.029,108 572.669,108 L 581.309,108" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 159 |
<path d="M602.189,123.12L745.786,123.12A15.12 15.12 0 0 0 760.906 108A15.12 15.12 0 0 0 745.786 92.88L602.189,92.88A15.12 15.12 0 0 0 587.069 108A15.12 15.12 0 0 0 602.189 123.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 160 |
<text x="673.987" y="108" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AUTOINCREMENT</text> |
| 161 |
<polygon points="783.946,108 772.426,112.32 772.426,103.68" style="fill:rgb(0,0,0)"/> |
| 162 |
<path d="M760.906,108L778.186,108" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 163 |
<polygon points="834.946,77.76 823.426,82.08 823.426,73.44" style="fill:rgb(0,0,0)"/> |
| 164 |
<path d="M783.946,108 L 791.446,108 Q 798.946,108 798.946,93 L 798.946,92.76 Q 798.946,77.76 813.946,77.76 L 814.186,77.76 L 829.186,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 165 |
<circle cx="838.546" cy="77.76" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 166 |
<polygon points="673.987,77.76 662.467,82.08 662.467,73.44" style="fill:rgb(0,0,0)"/> |
| 167 |
<path d="M549.029,77.76L668.227,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 168 |
<path d="M673.987,77.76L827.026,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 169 |
<polygon points="301.382,77.76 289.862,82.08 289.862,73.44" style="fill:rgb(0,0,0)"/> |
| 170 |
<path d="M233.102,77.76L295.622,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 171 |
<path d="M301.382,77.76L381.182,77.76" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 172 |
<polygon points="271.142,100.44 259.622,104.76 259.622,96.12" style="fill:rgb(0,0,0)"/> |
| 173 |
<path d="M233.102,77.76 L 240.602,77.76 Q 248.102,77.76 248.102,89.1 Q 248.102,100.44 256.742,100.44 L 265.382,100.44" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 174 |
<path d="M286.262,115.56L302.909,115.56A15.12 15.12 0 0 0 318.029 100.44A15.12 15.12 0 0 0 302.909 85.32L286.262,85.32A15.12 15.12 0 0 0 271.142 100.44A15.12 15.12 0 0 0 286.262 115.56Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 175 |
<text x="294.586" y="100.44" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ASC</text> |
| 176 |
<polygon points="354.662,100.44 343.142,104.76 343.142,96.12" style="fill:rgb(0,0,0)"/> |
| 177 |
<path d="M318.029,100.44L348.902,100.44" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 178 |
<path d="M354.662,100.44 L 362.162,100.44 Q 369.662,100.44 369.662,92.94 L 369.662,85.44" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 179 |
<polygon points="70.44,183.6 58.92,187.92 58.92,179.28" style="fill:rgb(0,0,0)"/> |
| 180 |
<path d="M47.4,62.64 L 47.4,168.6 Q 47.4,183.6 56.04,183.6 L 64.68,183.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 181 |
<path d="M85.56,198.72L105.662,198.72A15.12 15.12 0 0 0 120.782 183.6A15.12 15.12 0 0 0 105.662 168.48L85.56,168.48A15.12 15.12 0 0 0 70.44 183.6A15.12 15.12 0 0 0 85.56 198.72Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 182 |
<text x="95.6112" y="183.6" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text> |
| 183 |
<polygon points="143.822,183.6 132.302,187.92 132.302,179.28" style="fill:rgb(0,0,0)"/> |
| 184 |
<path d="M120.782,183.6L138.062,183.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 185 |
<path d="M158.942,198.72L190.104,198.72A15.12 15.12 0 0 0 205.224 183.6A15.12 15.12 0 0 0 190.104 168.48L158.942,168.48A15.12 15.12 0 0 0 143.822 183.6A15.12 15.12 0 0 0 158.942 198.72Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 186 |
<text x="174.523" y="183.6" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NULL</text> |
| 187 |
<polygon points="228.264,183.6 216.744,187.92 216.744,179.28" style="fill:rgb(0,0,0)"/> |
| 188 |
<path d="M205.224,183.6L222.504,183.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 189 |
<path d="M228.264,198.72L361.55,198.72L361.55,168.48L228.264,168.48Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 190 |
<text x="294.907" y="183.6" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text> |
| 191 |
<polygon points="783.946,183.6 772.426,187.92 772.426,179.28" style="fill:rgb(0,0,0)"/> |
| 192 |
<path d="M361.55,183.6L778.186,183.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 193 |
<path d="M783.946,183.6 L 791.446,183.6 Q 798.946,183.6 798.946,168.6 L 798.946,107.88 L 798.946,92.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 194 |
<polygon points="70.44,221.4 58.92,225.72 58.92,217.08" style="fill:rgb(0,0,0)"/> |
| 195 |
<path d="M47.4,168.48 L 47.4,206.4 Q 47.4,221.4 56.04,221.4 L 64.68,221.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 196 |
<path d="M85.56,236.52L140.453,236.52A15.12 15.12 0 0 0 155.573 221.4A15.12 15.12 0 0 0 140.453 206.28L85.56,206.28A15.12 15.12 0 0 0 70.44 221.4A15.12 15.12 0 0 0 85.56 236.52Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 197 |
<text x="113.006" y="221.4" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">UNIQUE</text> |
| 198 |
<polygon points="178.613,221.4 167.093,225.72 167.093,217.08" style="fill:rgb(0,0,0)"/> |
| 199 |
<path d="M155.573,221.4L172.853,221.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 200 |
<path d="M178.613,236.52L311.899,236.52L311.899,206.28L178.613,206.28Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 201 |
<text x="245.256" y="221.4" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text> |
| 202 |
<polygon points="783.946,221.4 772.426,225.72 772.426,217.08" style="fill:rgb(0,0,0)"/> |
| 203 |
<path d="M311.899,221.4L778.186,221.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 204 |
<path d="M783.946,221.4 L 791.446,221.4 Q 798.946,221.4 798.946,206.4 L 798.946,183.48 L 798.946,168.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 205 |
<polygon points="70.44,259.2 58.92,263.52 58.92,254.88" style="fill:rgb(0,0,0)"/> |
| 206 |
<path d="M47.4,206.28 L 47.4,244.2 Q 47.4,259.2 56.04,259.2 L 64.68,259.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 207 |
<path d="M85.56,274.32L131.006,274.32A15.12 15.12 0 0 0 146.126 259.2A15.12 15.12 0 0 0 131.006 244.08L85.56,244.08A15.12 15.12 0 0 0 70.44 259.2A15.12 15.12 0 0 0 85.56 274.32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 208 |
<text x="108.283" y="259.2" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CHECK</text> |
| 209 |
<polygon points="169.166,259.2 157.646,263.52 157.646,254.88" style="fill:rgb(0,0,0)"/> |
| 210 |
<path d="M146.126,259.2L163.406,259.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 211 |
<path d="M184.286,274.32A15.12 15.12 0 0 0 199.406 259.2A15.12 15.12 0 0 0 184.286 244.08A15.12 15.12 0 0 0 169.166 259.2A15.12 15.12 0 0 0 184.286 274.32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 212 |
<text x="184.286" y="259.2" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text> |
| 213 |
<polygon points="222.446,259.2 210.926,263.52 210.926,254.88" style="fill:rgb(0,0,0)"/> |
| 214 |
<path d="M199.406,259.2L216.686,259.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 215 |
<path d="M222.446,274.32L271.637,274.32L271.637,244.08L222.446,244.08Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 216 |
<text x="247.042" y="259.2" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> |
| 217 |
<polygon points="294.677,259.2 283.157,263.52 283.157,254.88" style="fill:rgb(0,0,0)"/> |
| 218 |
<path d="M271.637,259.2L288.917,259.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 219 |
<path d="M309.797,274.32A15.12 15.12 0 0 0 324.917 259.2A15.12 15.12 0 0 0 309.797 244.08A15.12 15.12 0 0 0 294.677 259.2A15.12 15.12 0 0 0 309.797 274.32Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 220 |
<text x="309.797" y="259.2" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text> |
| 221 |
<polygon points="783.946,259.2 772.426,263.52 772.426,254.88" style="fill:rgb(0,0,0)"/> |
| 222 |
<path d="M324.917,259.2L778.186,259.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 223 |
<path d="M783.946,259.2 L 791.446,259.2 Q 798.946,259.2 798.946,244.2 L 798.946,221.28 L 798.946,206.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 224 |
<polygon points="70.44,297 58.92,301.32 58.92,292.68" style="fill:rgb(0,0,0)"/> |
| 225 |
<path d="M47.4,244.08 L 47.4,282 Q 47.4,297 56.04,297 L 64.68,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 226 |
<path d="M85.56,312.12L150.936,312.12A15.12 15.12 0 0 0 166.056 297A15.12 15.12 0 0 0 150.936 281.88L85.56,281.88A15.12 15.12 0 0 0 70.44 297A15.12 15.12 0 0 0 85.56 312.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 227 |
<text x="118.248" y="297" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DEFAULT</text> |
| 228 |
<polygon points="189.096,297 177.576,301.32 177.576,292.68" style="fill:rgb(0,0,0)"/> |
| 229 |
<path d="M166.056,297L183.336,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 230 |
<polygon points="225.096,297 213.576,301.32 213.576,292.68" style="fill:rgb(0,0,0)"/> |
| 231 |
<path d="M189.096,297L219.336,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 232 |
<path d="M240.216,312.12A15.12 15.12 0 0 0 255.336 297A15.12 15.12 0 0 0 240.216 281.88A15.12 15.12 0 0 0 225.096 297A15.12 15.12 0 0 0 240.216 312.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 233 |
<text x="240.216" y="297" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text> |
| 234 |
<polygon points="278.376,297 266.856,301.32 266.856,292.68" style="fill:rgb(0,0,0)"/> |
| 235 |
<path d="M255.336,297L272.616,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 236 |
<path d="M278.376,312.12L327.566,312.12L327.566,281.88L278.376,281.88Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 237 |
<text x="302.971" y="297" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> |
| 238 |
<polygon points="350.606,297 339.086,301.32 339.086,292.68" style="fill:rgb(0,0,0)"/> |
| 239 |
<path d="M327.566,297L344.846,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 240 |
<path d="M365.726,312.12A15.12 15.12 0 0 0 380.846 297A15.12 15.12 0 0 0 365.726 281.88A15.12 15.12 0 0 0 350.606 297A15.12 15.12 0 0 0 365.726 312.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 241 |
<text x="365.726" y="297" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text> |
| 242 |
<polygon points="783.946,297 772.426,301.32 772.426,292.68" style="fill:rgb(0,0,0)"/> |
| 243 |
<path d="M380.846,297L778.186,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 244 |
<path d="M783.946,297 L 791.446,297 Q 798.946,297 798.946,282 L 798.946,259.08 L 798.946,244.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 245 |
<polygon points="227.136,334.8 215.616,339.12 215.616,330.48" style="fill:rgb(0,0,0)"/> |
| 246 |
<path d="M189.096,297 L 196.596,297 Q 204.096,297 204.096,312 L 204.096,319.8 Q 204.096,334.8 212.736,334.8 L 221.376,334.8" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 247 |
<path d="M227.136,349.92L340.032,349.92L340.032,319.68L227.136,319.68Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 248 |
<text x="283.584" y="334.8" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">literal-value</text> |
| 249 |
<polygon points="363.072,334.8 351.552,339.12 351.552,330.48" style="fill:rgb(0,0,0)"/> |
| 250 |
<path d="M340.032,334.8L357.312,334.8" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 251 |
<path d="M363.072,334.8 L 395.846,334.8 Q 410.846,334.8 410.846,319.8 L 410.846,312 Q 410.846,297 425.846,297 L 431.846,297 L 446.846,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 252 |
<polygon points="227.136,372.6 215.616,376.92 215.616,368.28" style="fill:rgb(0,0,0)"/> |
| 253 |
<path d="M189.096,297 L 196.596,297 Q 204.096,297 204.096,312 L 204.096,357.6 Q 204.096,372.6 212.736,372.6 L 221.376,372.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 254 |
<path d="M227.136,387.72L364.915,387.72L364.915,357.48L227.136,357.48Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 255 |
<text x="296.026" y="372.6" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">signed-number</text> |
| 256 |
<polygon points="387.955,372.6 376.435,376.92 376.435,368.28" style="fill:rgb(0,0,0)"/> |
| 257 |
<path d="M364.915,372.6L382.195,372.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 258 |
<path d="M387.955,372.6 L 399.401,372.6 Q 410.846,372.6 410.846,357.6 L 410.846,312 Q 410.846,297 425.846,297 L 431.846,297 L 446.846,297" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 259 |
<polygon points="70.44,410.4 58.92,414.72 58.92,406.08" style="fill:rgb(0,0,0)"/> |
| 260 |
<path d="M47.4,281.88 L 47.4,395.4 Q 47.4,410.4 56.04,410.4 L 64.68,410.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 261 |
<path d="M85.56,425.52L149.669,425.52A15.12 15.12 0 0 0 164.789 410.4A15.12 15.12 0 0 0 149.669 395.28L85.56,395.28A15.12 15.12 0 0 0 70.44 410.4A15.12 15.12 0 0 0 85.56 425.52Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 262 |
<text x="117.614" y="410.4" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLLATE</text> |
| 263 |
<polygon points="187.829,410.4 176.309,414.72 176.309,406.08" style="fill:rgb(0,0,0)"/> |
| 264 |
<path d="M164.789,410.4L182.069,410.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 265 |
<path d="M202.949,425.52L308.299,425.52A15.12 15.12 0 0 0 323.419 410.4A15.12 15.12 0 0 0 308.299 395.28L202.949,395.28A15.12 15.12 0 0 0 187.829 410.4A15.12 15.12 0 0 0 202.949 425.52Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 266 |
<text x="255.624" y="410.4" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">collation-name</text> |
| 267 |
<polygon points="783.946,410.4 772.426,414.72 772.426,406.08" style="fill:rgb(0,0,0)"/> |
| 268 |
<path d="M323.419,410.4L778.186,410.4" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 269 |
<path d="M783.946,410.4 L 791.446,410.4 Q 798.946,410.4 798.946,395.4 L 798.946,296.88 L 798.946,281.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 270 |
<polygon points="70.44,448.2 58.92,452.52 58.92,443.88" style="fill:rgb(0,0,0)"/> |
| 271 |
<path d="M47.4,395.28 L 47.4,433.2 Q 47.4,448.2 56.04,448.2 L 64.68,448.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 272 |
<path d="M70.44,463.32L236.098,463.32L236.098,433.08L70.44,433.08Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 273 |
<text x="153.269" y="448.2" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">foreign-key-clause</text> |
| 274 |
<polygon points="783.946,448.2 772.426,452.52 772.426,443.88" style="fill:rgb(0,0,0)"/> |
| 275 |
<path d="M236.098,448.2L778.186,448.2" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 276 |
<path d="M783.946,448.2 L 791.446,448.2 Q 798.946,448.2 798.946,433.2 L 798.946,410.28 L 798.946,395.28" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 277 |
<polygon points="70.44,486 58.92,490.32 58.92,481.68" style="fill:rgb(0,0,0)"/> |
| 278 |
<path d="M47.4,433.08 L 47.4,471 Q 47.4,486 56.04,486 L 64.68,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 279 |
<path d="M85.56,501.12L178.123,501.12A15.12 15.12 0 0 0 193.243 486A15.12 15.12 0 0 0 178.123 470.88L85.56,470.88A15.12 15.12 0 0 0 70.44 486A15.12 15.12 0 0 0 85.56 501.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 280 |
<text x="131.842" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">GENERATED</text> |
| 281 |
<polygon points="216.283,486 204.763,490.32 204.763,481.68" style="fill:rgb(0,0,0)"/> |
| 282 |
<path d="M193.243,486L210.523,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 283 |
<path d="M231.403,501.12L286.066,501.12A15.12 15.12 0 0 0 301.186 486A15.12 15.12 0 0 0 286.066 470.88L231.403,470.88A15.12 15.12 0 0 0 216.283 486A15.12 15.12 0 0 0 231.403 501.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 284 |
<text x="258.734" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALWAYS</text> |
| 285 |
<polygon points="337.186,486 325.666,490.32 325.666,481.68" style="fill:rgb(0,0,0)"/> |
| 286 |
<path d="M301.186,486L331.426,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 287 |
<path d="M352.306,501.12L356.28,501.12A15.12 15.12 0 0 0 371.4 486A15.12 15.12 0 0 0 356.28 470.88L352.306,470.88A15.12 15.12 0 0 0 337.186 486A15.12 15.12 0 0 0 352.306 501.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 288 |
<text x="354.293" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">AS</text> |
| 289 |
<polygon points="394.44,486 382.92,490.32 382.92,481.68" style="fill:rgb(0,0,0)"/> |
| 290 |
<path d="M371.4,486L388.68,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 291 |
<path d="M409.56,501.12A15.12 15.12 0 0 0 424.68 486A15.12 15.12 0 0 0 409.56 470.88A15.12 15.12 0 0 0 394.44 486A15.12 15.12 0 0 0 409.56 501.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 292 |
<text x="409.56" y="486" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text> |
| 293 |
<polygon points="447.72,486 436.2,490.32 436.2,481.68" style="fill:rgb(0,0,0)"/> |
| 294 |
<path d="M424.68,486L441.96,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 295 |
<path d="M447.72,501.12L496.91,501.12L496.91,470.88L447.72,470.88Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 296 |
<text x="472.315" y="486" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text> |
| 297 |
<polygon points="519.95,486 508.43,490.32 508.43,481.68" style="fill:rgb(0,0,0)"/> |
| 298 |
<path d="M496.91,486L514.19,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 299 |
<path d="M535.07,501.12A15.12 15.12 0 0 0 550.19 486A15.12 15.12 0 0 0 535.07 470.88A15.12 15.12 0 0 0 519.95 486A15.12 15.12 0 0 0 535.07 501.12Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 300 |
<text x="535.07" y="486" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text> |
| 301 |
<polygon points="783.946,486 772.426,490.32 772.426,481.68" style="fill:rgb(0,0,0)"/> |
| 302 |
<path d="M550.19,486L778.186,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 303 |
<path d="M783.946,486 L 791.446,486 Q 798.946,486 798.946,471 L 798.946,448.08 L 798.946,433.08" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 304 |
<polygon points="185.813,516.24 174.293,520.56 174.293,511.92" style="fill:rgb(0,0,0)"/> |
| 305 |
<path d="M47.4,470.88 L 47.4,501.24 Q 47.4,516.24 62.4,516.24 L 165.053,516.24 L 180.053,516.24" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 306 |
<path d="M185.813,516.24 L 297.706,516.24 Q 312.706,516.24 312.706,501.24 L 312.706,501 Q 312.706,486 320.206,486 L 327.706,486" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 307 |
<polygon points="596.27,561.6 584.75,565.92 584.75,557.28" style="fill:rgb(0,0,0)"/> |
| 308 |
<path d="M550.19,486 L 561.71,486 Q 573.23,486 573.23,501 L 573.23,546.6 Q 573.23,561.6 581.87,561.6 L 590.51,561.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 309 |
<path d="M611.39,576.72L670.891,576.72A15.12 15.12 0 0 0 686.011 561.6A15.12 15.12 0 0 0 670.891 546.48L611.39,546.48A15.12 15.12 0 0 0 596.27 561.6A15.12 15.12 0 0 0 611.39 576.72Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 310 |
<text x="641.141" y="561.6" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VIRTUAL</text> |
| 311 |
<polygon points="783.946,561.6 772.426,565.92 772.426,557.28" style="fill:rgb(0,0,0)"/> |
| 312 |
<path d="M686.011,561.6L778.186,561.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 313 |
<path d="M783.946,561.6 L 791.446,561.6 Q 798.946,561.6 798.946,546.6 L 798.946,485.88 L 798.946,470.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 314 |
<polygon points="596.27,523.8 584.75,528.12 584.75,519.48" style="fill:rgb(0,0,0)"/> |
| 315 |
<path d="M550.19,486 L 561.71,486 Q 573.23,486 573.23,501 L 573.23,508.8 Q 573.23,523.8 581.87,523.8 L 590.51,523.8" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 316 |
<path d="M611.39,538.92L665.707,538.92A15.12 15.12 0 0 0 680.827 523.8A15.12 15.12 0 0 0 665.707 508.68L611.39,508.68A15.12 15.12 0 0 0 596.27 523.8A15.12 15.12 0 0 0 611.39 538.92Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 317 |
<text x="638.549" y="523.8" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">STORED</text> |
| 318 |
<polygon points="783.946,523.8 772.426,528.12 772.426,519.48" style="fill:rgb(0,0,0)"/> |
| 319 |
<path d="M680.827,523.8L778.186,523.8" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 320 |
<path d="M783.946,523.8 L 791.446,523.8 Q 798.946,523.8 798.946,516.3 L 798.946,508.8" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> |
| 321 |
</svg> |
| 322 |
</div><br> |
| 323 |
|
| 324 |
Used by: <a href='./column-def.html'>column-def</a><br></br> |
| 325 |
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> |
| 326 |
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> |
| 327 |
</div> |
| 328 |
|
| 329 |
|
| 330 |
|