Debian Codegraph @

www/syntax/alter-table-stmt.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>SQLite Syntax: alter-table-stmt</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'>alter-table-stmt</h1>
119 <div class='imgcontainer'>
120 <div style="max-width:809px"><svg xmlns='http://www.w3.org/2000/svg' style='font-size:initial;' class="pikchr" viewBox="0 0 809.23 691.056" data-pikchr-date="20250319161943">
121 <circle cx="5.76" cy="32.688" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
122 <polygon points="37.7065,32.688 26.1865,37.008 26.1865,28.368" style="fill:rgb(0,0,0)"/>
123 <path d="M9.36,32.688L31.9465,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
124 <path d="M37.7065,32.688L59.3065,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
125 <path d="M74.4265,47.808L113.998,47.808A15.12 15.12 0 0 0 129.118 32.688A15.12 15.12 0 0 0 113.998 17.568L74.4265,17.568A15.12 15.12 0 0 0 59.3065 32.688A15.12 15.12 0 0 0 74.4265 47.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
126 <text x="94.2121" y="32.688" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALTER</text>
127 <polygon points="165.118,32.688 153.598,37.008 153.598,28.368" style="fill:rgb(0,0,0)"/>
128 <path d="M129.118,32.688L159.358,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
129 <path d="M180.238,47.808L219.578,47.808A15.12 15.12 0 0 0 234.698 32.688A15.12 15.12 0 0 0 219.578 17.568L180.238,17.568A15.12 15.12 0 0 0 165.118 32.688A15.12 15.12 0 0 0 180.238 47.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
130 <text x="199.908" y="32.688" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TABLE</text>
131 <polygon points="251.706,32.688 240.186,37.008 240.186,28.368" style="fill:rgb(0,0,0)"/>
132 <path d="M234.698,32.688L245.946,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
133 <polygon points="287.706,32.688 276.186,37.008 276.186,28.368" style="fill:rgb(0,0,0)"/>
134 <path d="M251.706,32.688L281.946,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
135 <path d="M302.826,47.808L399.191,47.808A15.12 15.12 0 0 0 414.311 32.688A15.12 15.12 0 0 0 399.191 17.568L302.826,17.568A15.12 15.12 0 0 0 287.706 32.688A15.12 15.12 0 0 0 302.826 47.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
136 <text x="351.009" y="32.688" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text>
137 <polygon points="436.988,32.688 425.468,37.008 425.468,28.368" style="fill:rgb(0,0,0)"/>
138 <path d="M414.311,32.688L431.228,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
139 <path d="M452.108,47.808A15.12 15.12 0 0 0 467.228 32.688A15.12 15.12 0 0 0 452.108 17.568A15.12 15.12 0 0 0 436.988 32.688A15.12 15.12 0 0 0 452.108 47.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
140 <text x="452.108" y="32.688" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">.</text>
141 <polygon points="503.228,32.688 491.708,37.008 491.708,28.368" style="fill:rgb(0,0,0)"/>
142 <path d="M467.228,32.688L497.468,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
143 <path d="M518.348,47.808L593.516,47.808A15.12 15.12 0 0 0 608.636 32.688A15.12 15.12 0 0 0 593.516 17.568L518.348,17.568A15.12 15.12 0 0 0 503.228 32.688A15.12 15.12 0 0 0 518.348 47.808Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
144 <text x="555.932" y="32.688" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text>
145 <polygon points="376.33,6.48 364.81,10.8 364.81,2.16" style="fill:rgb(0,0,0)"/>
146 <path d="M251.706,32.688 L 260.21,32.688 Q 268.714,32.688 268.714,19.584 Q 268.714,6.48 283.714,6.48 L 355.57,6.48 L 370.57,6.48" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
147 <path d="M376.33,6.48 L 461.228,6.48 Q 476.228,6.48 476.228,19.584 Q 476.228,32.688 489.728,32.688 L 503.228,32.688" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
148 <polygon points="626.636,56.88 622.316,45.36 630.956,45.36" style="fill:rgb(0,0,0)"/>
149 <path d="M608.636,32.688 L 617.636,32.688 Q 626.636,32.688 626.636,41.904 L 626.636,51.12" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
150 <polygon points="351.009,81.072 362.529,76.752 362.529,85.392" style="fill:rgb(0,0,0)"/>
151 <path d="M626.636,56.88 L 626.636,68.976 Q 626.636,81.072 611.636,81.072 L 371.769,81.072 L 356.769,81.072" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
152 <path d="M351.009,81.072 L 20.76,81.072 Q 5.76,81.072 5.76,88.632 L 5.76,96.192" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
153 <polygon points="41.76,126.432 30.24,130.752 30.24,122.112" style="fill:rgb(0,0,0)"/>
154 <path d="M5.76,96.192 L 5.76,111.432 Q 5.76,126.432 20.76,126.432 L 21,126.432 L 36,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
155 <path d="M56.88,141.552L117.533,141.552A15.12 15.12 0 0 0 132.653 126.432A15.12 15.12 0 0 0 117.533 111.312L56.88,111.312A15.12 15.12 0 0 0 41.76 126.432A15.12 15.12 0 0 0 56.88 141.552Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
156 <text x="87.2064" y="126.432" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">RENAME</text>
157 <path d="M132.653,126.432L189.346,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
158 <polygon points="206.354,126.432 194.834,130.752 194.834,122.112" style="fill:rgb(0,0,0)"/>
159 <path d="M189.346,126.432L200.594,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
160 <path d="M221.474,141.552L227.176,141.552A15.12 15.12 0 0 0 242.296 126.432A15.12 15.12 0 0 0 227.176 111.312L221.474,111.312A15.12 15.12 0 0 0 206.354 126.432A15.12 15.12 0 0 0 221.474 141.552Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
161 <text x="224.325" y="126.432" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TO</text>
162 <polygon points="259.304,126.432 247.784,130.752 247.784,122.112" style="fill:rgb(0,0,0)"/>
163 <path d="M242.296,126.432L253.544,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
164 <path d="M274.424,141.552L389.451,141.552A15.12 15.12 0 0 0 404.571 126.432A15.12 15.12 0 0 0 389.451 111.312L274.424,111.312A15.12 15.12 0 0 0 259.304 126.432A15.12 15.12 0 0 0 274.424 141.552Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
165 <text x="331.937" y="126.432" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">new-table-name</text>
166 <polygon points="421.579,126.432 410.059,130.752 410.059,122.112" style="fill:rgb(0,0,0)"/>
167 <path d="M404.571,126.432L415.819,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
168 <polygon points="206.354,171.792 194.834,176.112 194.834,167.472" style="fill:rgb(0,0,0)"/>
169 <path d="M132.653,126.432 L 141.157,126.432 Q 149.661,126.432 149.661,141.432 L 149.661,156.792 Q 149.661,171.792 164.661,171.792 L 185.594,171.792 L 200.594,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
170 <path d="M221.474,186.912L284.315,186.912A15.12 15.12 0 0 0 299.435 171.792A15.12 15.12 0 0 0 284.315 156.672L221.474,156.672A15.12 15.12 0 0 0 206.354 171.792A15.12 15.12 0 0 0 221.474 186.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
171 <text x="252.894" y="171.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text>
172 <polygon points="316.443,171.792 304.923,176.112 304.923,167.472" style="fill:rgb(0,0,0)"/>
173 <path d="M299.435,171.792L310.683,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
174 <polygon points="352.443,171.792 340.923,176.112 340.923,167.472" style="fill:rgb(0,0,0)"/>
175 <path d="M316.443,171.792L346.683,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
176 <path d="M367.563,186.912L461.624,186.912A15.12 15.12 0 0 0 476.744 171.792A15.12 15.12 0 0 0 461.624 156.672L367.563,156.672A15.12 15.12 0 0 0 352.443 171.792A15.12 15.12 0 0 0 367.563 186.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
177 <text x="414.593" y="171.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text>
178 <polygon points="493.752,171.792 482.232,176.112 482.232,167.472" style="fill:rgb(0,0,0)"/>
179 <path d="M476.744,171.792L487.992,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
180 <path d="M508.872,186.912L514.574,186.912A15.12 15.12 0 0 0 529.694 171.792A15.12 15.12 0 0 0 514.574 156.672L508.872,156.672A15.12 15.12 0 0 0 493.752 171.792A15.12 15.12 0 0 0 508.872 186.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
181 <text x="511.723" y="171.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TO</text>
182 <polygon points="546.702,171.792 535.182,176.112 535.182,167.472" style="fill:rgb(0,0,0)"/>
183 <path d="M529.694,171.792L540.942,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
184 <path d="M561.822,186.912L695.742,186.912A15.12 15.12 0 0 0 710.862 171.792A15.12 15.12 0 0 0 695.742 156.672L561.822,156.672A15.12 15.12 0 0 0 546.702 171.792A15.12 15.12 0 0 0 561.822 186.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
185 <text x="628.782" y="171.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">new-column-name</text>
186 <polygon points="727.87,171.792 716.35,176.112 716.35,167.472" style="fill:rgb(0,0,0)"/>
187 <path d="M710.862,171.792L722.11,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
188 <polygon points="252.894,195.984 241.374,200.304 241.374,191.664" style="fill:rgb(0,0,0)"/>
189 <path d="M172.338,171.792 L 180.842,171.792 Q 189.346,171.792 189.346,183.888 Q 189.346,195.984 204.346,195.984 L 232.134,195.984 L 247.134,195.984" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
190 <path d="M252.894,195.984 L 301.443,195.984 Q 316.443,195.984 316.443,183.888 Q 316.443,171.792 324.947,171.792 L 333.451,171.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
191 <polygon points="41.76,241.344 30.24,245.664 30.24,237.024" style="fill:rgb(0,0,0)"/>
192 <path d="M5.76,88.632 L 5.76,226.344 Q 5.76,241.344 20.76,241.344 L 21,241.344 L 36,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
193 <path d="M56.88,256.464L76.4064,256.464A15.12 15.12 0 0 0 91.5264 241.344A15.12 15.12 0 0 0 76.4064 226.224L56.88,226.224A15.12 15.12 0 0 0 41.76 241.344A15.12 15.12 0 0 0 56.88 256.464Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
194 <text x="66.6432" y="241.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ADD</text>
195 <path d="M91.5264,241.344L148.219,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
196 <polygon points="165.227,241.344 153.707,245.664 153.707,237.024" style="fill:rgb(0,0,0)"/>
197 <path d="M148.219,241.344L159.467,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
198 <path d="M180.347,256.464L243.189,256.464A15.12 15.12 0 0 0 258.309 241.344A15.12 15.12 0 0 0 243.189 226.224L180.347,226.224A15.12 15.12 0 0 0 165.227 241.344A15.12 15.12 0 0 0 180.347 256.464Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
199 <text x="211.768" y="241.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text>
200 <polygon points="294.309,241.344 282.789,245.664 282.789,237.024" style="fill:rgb(0,0,0)"/>
201 <path d="M258.309,241.344L288.549,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
202 <path d="M294.309,256.464L399.141,256.464L399.141,226.224L294.309,226.224Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
203 <text x="346.725" y="241.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-def</text>
204 <polygon points="416.149,241.344 404.629,245.664 404.629,237.024" style="fill:rgb(0,0,0)"/>
205 <path d="M399.141,241.344L410.389,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
206 <polygon points="211.768,265.536 200.248,269.856 200.248,261.216" style="fill:rgb(0,0,0)"/>
207 <path d="M131.211,241.344 L 139.715,241.344 Q 148.219,241.344 148.219,253.44 Q 148.219,265.536 163.219,265.536 L 191.008,265.536 L 206.008,265.536" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
208 <path d="M211.768,265.536 L 260.317,265.536 Q 275.317,265.536 275.317,253.44 Q 275.317,241.344 283.821,241.344 L 292.325,241.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
209 <polygon points="165.227,295.776 153.707,300.096 153.707,291.456" style="fill:rgb(0,0,0)"/>
210 <path d="M91.5264,241.344 L 100.03,241.344 Q 108.534,241.344 108.534,256.344 L 108.534,280.776 Q 108.534,295.776 123.534,295.776 L 144.467,295.776 L 159.467,295.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
211 <path d="M180.347,310.896L280.398,310.896A15.12 15.12 0 0 0 295.518 295.776A15.12 15.12 0 0 0 280.398 280.656L180.347,280.656A15.12 15.12 0 0 0 165.227 295.776A15.12 15.12 0 0 0 180.347 310.896Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
212 <text x="230.373" y="295.776" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CONSTRAINT</text>
213 <polygon points="312.526,295.776 301.006,300.096 301.006,291.456" style="fill:rgb(0,0,0)"/>
214 <path d="M295.518,295.776L306.766,295.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
215 <path d="M327.646,310.896L445.899,310.896A15.12 15.12 0 0 0 461.019 295.776A15.12 15.12 0 0 0 445.899 280.656L327.646,280.656A15.12 15.12 0 0 0 312.526 295.776A15.12 15.12 0 0 0 327.646 310.896Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
216 <text x="386.773" y="295.776" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">constraint-name</text>
217 <polygon points="497.019,295.776 485.499,300.096 485.499,291.456" style="fill:rgb(0,0,0)"/>
218 <path d="M461.019,295.776L491.259,295.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
219 <polygon points="386.773,319.968 375.253,324.288 375.253,315.648" style="fill:rgb(0,0,0)"/>
220 <path d="M131.211,295.776 L 139.715,295.776 Q 148.219,295.776 148.219,307.872 Q 148.219,319.968 163.219,319.968 L 366.013,319.968 L 381.013,319.968" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
221 <path d="M386.773,319.968 L 463.027,319.968 Q 478.027,319.968 478.027,307.872 Q 478.027,295.776 486.531,295.776 L 495.035,295.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
222 <polygon points="201.227,365.328 189.707,369.648 189.707,361.008" style="fill:rgb(0,0,0)"/>
223 <path d="M495.035,295.776 L 504.035,295.776 Q 513.035,295.776 513.035,310.776 L 513.035,320.088 Q 513.035,335.088 498.035,335.088 L 180.227,335.088 Q 165.227,335.088 165.227,350.088 L 165.227,350.328 Q 165.227,365.328 180.227,365.328 L 180.467,365.328 L 195.467,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
224 <path d="M216.347,380.448L261.794,380.448A15.12 15.12 0 0 0 276.914 365.328A15.12 15.12 0 0 0 261.794 350.208L216.347,350.208A15.12 15.12 0 0 0 201.227 365.328A15.12 15.12 0 0 0 216.347 380.448Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
225 <text x="239.07" y="365.328" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CHECK</text>
226 <polygon points="312.914,365.328 301.394,369.648 301.394,361.008" style="fill:rgb(0,0,0)"/>
227 <path d="M276.914,365.328L307.154,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
228 <path d="M328.034,380.448A15.12 15.12 0 0 0 343.154 365.328A15.12 15.12 0 0 0 328.034 350.208A15.12 15.12 0 0 0 312.914 365.328A15.12 15.12 0 0 0 328.034 380.448Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
229 <text x="328.034" y="365.328" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
230 <polygon points="379.154,365.328 367.634,369.648 367.634,361.008" style="fill:rgb(0,0,0)"/>
231 <path d="M343.154,365.328L373.394,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
232 <path d="M379.154,380.448L428.344,380.448L428.344,350.208L379.154,350.208Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
233 <text x="403.749" y="365.328" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">expr</text>
234 <polygon points="464.344,365.328 452.824,369.648 452.824,361.008" style="fill:rgb(0,0,0)"/>
235 <path d="M428.344,365.328L458.584,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
236 <path d="M479.464,380.448A15.12 15.12 0 0 0 494.584 365.328A15.12 15.12 0 0 0 479.464 350.208A15.12 15.12 0 0 0 464.344 365.328A15.12 15.12 0 0 0 479.464 380.448Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
237 <text x="479.464" y="365.328" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
238 <polygon points="530.584,365.328 519.064,369.648 519.064,361.008" style="fill:rgb(0,0,0)"/>
239 <path d="M494.584,365.328L524.824,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
240 <path d="M530.584,380.448L663.87,380.448L663.87,350.208L530.584,350.208Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
241 <text x="597.227" y="365.328" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text>
242 <polygon points="680.878,365.328 669.358,369.648 669.358,361.008" style="fill:rgb(0,0,0)"/>
243 <path d="M663.87,365.328L675.118,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
244 <polygon points="716.878,365.328 705.358,369.648 705.358,361.008" style="fill:rgb(0,0,0)"/>
245 <path d="M680.878,365.328L711.118,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
246 <polygon points="597.227,389.52 585.707,393.84 585.707,385.2" style="fill:rgb(0,0,0)"/>
247 <path d="M496.568,365.328 L 505.072,365.328 Q 513.576,365.328 513.576,377.424 Q 513.576,389.52 528.576,389.52 L 576.467,389.52 L 591.467,389.52" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
248 <path d="M597.227,389.52 L 665.878,389.52 Q 680.878,389.52 680.878,377.424 Q 680.878,365.328 689.382,365.328 L 697.886,365.328" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
249 <polygon points="41.76,434.88 30.24,439.2 30.24,430.56" style="fill:rgb(0,0,0)"/>
250 <path d="M5.76,88.632 L 5.76,419.88 Q 5.76,434.88 20.76,434.88 L 21,434.88 L 36,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
251 <path d="M56.88,450L87.9264,450A15.12 15.12 0 0 0 103.046 434.88A15.12 15.12 0 0 0 87.9264 419.76L56.88,419.76A15.12 15.12 0 0 0 41.76 434.88A15.12 15.12 0 0 0 56.88 450Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
252 <text x="72.4032" y="434.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DROP</text>
253 <path d="M103.046,434.88L159.739,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
254 <polygon points="176.747,434.88 165.227,439.2 165.227,430.56" style="fill:rgb(0,0,0)"/>
255 <path d="M159.739,434.88L170.987,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
256 <path d="M191.867,450L254.709,450A15.12 15.12 0 0 0 269.829 434.88A15.12 15.12 0 0 0 254.709 419.76L191.867,419.76A15.12 15.12 0 0 0 176.747 434.88A15.12 15.12 0 0 0 191.867 450Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
257 <text x="223.288" y="434.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text>
258 <polygon points="305.829,434.88 294.309,439.2 294.309,430.56" style="fill:rgb(0,0,0)"/>
259 <path d="M269.829,434.88L300.069,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
260 <path d="M320.949,450L415.01,450A15.12 15.12 0 0 0 430.13 434.88A15.12 15.12 0 0 0 415.01 419.76L320.949,419.76A15.12 15.12 0 0 0 305.829 434.88A15.12 15.12 0 0 0 320.949 450Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
261 <text x="367.979" y="434.88" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text>
262 <polygon points="447.137,434.88 435.617,439.2 435.617,430.56" style="fill:rgb(0,0,0)"/>
263 <path d="M430.13,434.88L441.377,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
264 <polygon points="223.288,459.072 211.768,463.392 211.768,454.752" style="fill:rgb(0,0,0)"/>
265 <path d="M142.731,434.88 L 151.235,434.88 Q 159.739,434.88 159.739,446.976 Q 159.739,459.072 174.739,459.072 L 202.528,459.072 L 217.528,459.072" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
266 <path d="M223.288,459.072 L 271.837,459.072 Q 286.837,459.072 286.837,446.976 Q 286.837,434.88 295.341,434.88 L 303.845,434.88" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
267 <polygon points="176.747,489.312 165.227,493.632 165.227,484.992" style="fill:rgb(0,0,0)"/>
268 <path d="M103.046,434.88 L 111.55,434.88 Q 120.054,434.88 120.054,449.88 L 120.054,474.312 Q 120.054,489.312 135.054,489.312 L 155.987,489.312 L 170.987,489.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
269 <path d="M191.867,504.432L291.918,504.432A15.12 15.12 0 0 0 307.038 489.312A15.12 15.12 0 0 0 291.918 474.192L191.867,474.192A15.12 15.12 0 0 0 176.747 489.312A15.12 15.12 0 0 0 191.867 504.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
270 <text x="241.893" y="489.312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CONSTRAINT</text>
271 <polygon points="324.046,489.312 312.526,493.632 312.526,484.992" style="fill:rgb(0,0,0)"/>
272 <path d="M307.038,489.312L318.286,489.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
273 <path d="M339.166,504.432L457.419,504.432A15.12 15.12 0 0 0 472.539 489.312A15.12 15.12 0 0 0 457.419 474.192L339.166,474.192A15.12 15.12 0 0 0 324.046 489.312A15.12 15.12 0 0 0 339.166 504.432Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
274 <text x="398.293" y="489.312" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">constraint-name</text>
275 <polygon points="489.547,489.312 478.027,493.632 478.027,484.992" style="fill:rgb(0,0,0)"/>
276 <path d="M472.539,489.312L483.787,489.312" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
277 <polygon points="41.76,549.792 30.24,554.112 30.24,545.472" style="fill:rgb(0,0,0)"/>
278 <path d="M5.76,88.632 L 5.76,534.792 Q 5.76,549.792 20.76,549.792 L 21,549.792 L 36,549.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
279 <path d="M56.88,564.912L96.4512,564.912A15.12 15.12 0 0 0 111.571 549.792A15.12 15.12 0 0 0 96.4512 534.672L56.88,534.672A15.12 15.12 0 0 0 41.76 549.792A15.12 15.12 0 0 0 56.88 564.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
280 <text x="76.6656" y="549.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALTER</text>
281 <polygon points="147.571,549.792 136.051,554.112 136.051,545.472" style="fill:rgb(0,0,0)"/>
282 <path d="M111.571,549.792L141.811,549.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
283 <path d="M162.691,564.912L225.533,564.912A15.12 15.12 0 0 0 240.653 549.792A15.12 15.12 0 0 0 225.533 534.672L162.691,534.672A15.12 15.12 0 0 0 147.571 549.792A15.12 15.12 0 0 0 162.691 564.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
284 <text x="194.112" y="549.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text>
285 <polygon points="257.661,549.792 246.141,554.112 246.141,545.472" style="fill:rgb(0,0,0)"/>
286 <path d="M240.653,549.792L251.901,549.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
287 <polygon points="293.661,549.792 282.141,554.112 282.141,545.472" style="fill:rgb(0,0,0)"/>
288 <path d="M257.661,549.792L287.901,549.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
289 <path d="M308.781,564.912L402.841,564.912A15.12 15.12 0 0 0 417.961 549.792A15.12 15.12 0 0 0 402.841 534.672L308.781,534.672A15.12 15.12 0 0 0 293.661 549.792A15.12 15.12 0 0 0 308.781 564.912Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
290 <text x="355.811" y="549.792" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text>
291 <polygon points="194.112,573.984 182.592,578.304 182.592,569.664" style="fill:rgb(0,0,0)"/>
292 <path d="M113.555,549.792 L 122.059,549.792 Q 130.563,549.792 130.563,561.888 Q 130.563,573.984 145.563,573.984 L 173.352,573.984 L 188.352,573.984" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
293 <path d="M194.112,573.984 L 242.661,573.984 Q 257.661,573.984 257.661,561.888 Q 257.661,549.792 266.165,549.792 L 274.669,549.792" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
294 <polygon points="183.571,619.344 172.051,623.664 172.051,615.024" style="fill:rgb(0,0,0)"/>
295 <path d="M417.961,549.792 L 426.961,549.792 Q 435.961,549.792 435.961,564.792 L 435.961,574.104 Q 435.961,589.104 420.961,589.104 L 162.571,589.104 Q 147.571,589.104 147.571,604.104 L 147.571,604.344 Q 147.571,619.344 162.571,619.344 L 162.811,619.344 L 177.811,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
296 <path d="M198.691,634.464L214.186,634.464A15.12 15.12 0 0 0 229.306 619.344A15.12 15.12 0 0 0 214.186 604.224L198.691,604.224A15.12 15.12 0 0 0 183.571 619.344A15.12 15.12 0 0 0 198.691 634.464Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
297 <text x="206.438" y="619.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">SET</text>
298 <polygon points="246.313,619.344 234.793,623.664 234.793,615.024" style="fill:rgb(0,0,0)"/>
299 <path d="M229.306,619.344L240.553,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
300 <path d="M261.433,634.464L281.536,634.464A15.12 15.12 0 0 0 296.656 619.344A15.12 15.12 0 0 0 281.536 604.224L261.433,604.224A15.12 15.12 0 0 0 246.313 619.344A15.12 15.12 0 0 0 261.433 634.464Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
301 <text x="271.485" y="619.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text>
302 <polygon points="313.664,619.344 302.144,623.664 302.144,615.024" style="fill:rgb(0,0,0)"/>
303 <path d="M296.656,619.344L307.904,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
304 <path d="M328.784,634.464L359.945,634.464A15.12 15.12 0 0 0 375.065 619.344A15.12 15.12 0 0 0 359.945 604.224L328.784,604.224A15.12 15.12 0 0 0 313.664 619.344A15.12 15.12 0 0 0 328.784 634.464Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
305 <text x="344.365" y="619.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NULL</text>
306 <polygon points="411.065,619.344 399.545,623.664 399.545,615.024" style="fill:rgb(0,0,0)"/>
307 <path d="M375.065,619.344L405.305,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
308 <path d="M411.065,634.464L544.352,634.464L544.352,604.224L411.065,604.224Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
309 <text x="477.709" y="619.344" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">conflict-clause</text>
310 <polygon points="561.36,619.344 549.84,623.664 549.84,615.024" style="fill:rgb(0,0,0)"/>
311 <path d="M544.352,619.344L555.6,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
312 <polygon points="597.36,619.344 585.84,623.664 585.84,615.024" style="fill:rgb(0,0,0)"/>
313 <path d="M561.36,619.344L591.6,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
314 <polygon points="477.709,643.536 466.189,647.856 466.189,639.216" style="fill:rgb(0,0,0)"/>
315 <path d="M377.05,619.344 L 385.554,619.344 Q 394.057,619.344 394.057,631.44 Q 394.057,643.536 409.057,643.536 L 456.949,643.536 L 471.949,643.536" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
316 <path d="M477.709,643.536 L 546.36,643.536 Q 561.36,643.536 561.36,631.44 Q 561.36,619.344 569.864,619.344 L 578.367,619.344" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
317 <polygon points="183.571,673.776 172.051,678.096 172.051,669.456" style="fill:rgb(0,0,0)"/>
318 <path d="M147.571,599.688 L 147.571,658.776 Q 147.571,673.776 162.571,673.776 L 162.811,673.776 L 177.811,673.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
319 <path d="M198.691,688.896L229.738,688.896A15.12 15.12 0 0 0 244.858 673.776A15.12 15.12 0 0 0 229.738 658.656L198.691,658.656A15.12 15.12 0 0 0 183.571 673.776A15.12 15.12 0 0 0 198.691 688.896Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
320 <text x="214.214" y="673.776" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DROP</text>
321 <polygon points="261.865,673.776 250.345,678.096 250.345,669.456" style="fill:rgb(0,0,0)"/>
322 <path d="M244.858,673.776L256.105,673.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
323 <path d="M276.985,688.896L297.088,688.896A15.12 15.12 0 0 0 312.208 673.776A15.12 15.12 0 0 0 297.088 658.656L276.985,658.656A15.12 15.12 0 0 0 261.865 673.776A15.12 15.12 0 0 0 276.985 688.896Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
324 <text x="287.037" y="673.776" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text>
325 <polygon points="329.216,673.776 317.696,678.096 317.696,669.456" style="fill:rgb(0,0,0)"/>
326 <path d="M312.208,673.776L323.456,673.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
327 <path d="M344.336,688.896L375.497,688.896A15.12 15.12 0 0 0 390.617 673.776A15.12 15.12 0 0 0 375.497 658.656L344.336,658.656A15.12 15.12 0 0 0 329.216 673.776A15.12 15.12 0 0 0 344.336 688.896Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
328 <text x="359.917" y="673.776" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NULL</text>
329 <polygon points="407.625,673.776 396.105,678.096 396.105,669.456" style="fill:rgb(0,0,0)"/>
330 <path d="M390.617,673.776L401.865,673.776" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
331 <path d="M727.87,171.792 L 748.87,171.792 Q 763.87,171.792 763.87,163.288 L 763.87,154.784" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
332 <polygon points="799.87,126.432 788.35,130.752 788.35,122.112" style="fill:rgb(0,0,0)"/>
333 <path d="M763.87,154.784 L 763.87,140.608 Q 763.87,126.432 778.87,126.432 L 779.11,126.432 L 794.11,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
334 <circle cx="803.47" cy="126.432" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
335 <path d="M421.579,126.432L799.87,126.432" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
336 <path d="M416.149,241.344 L 748.87,241.344 Q 763.87,241.344 763.87,226.344 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
337 <path d="M716.878,365.328 L 748.87,365.328 Q 763.87,365.328 763.87,350.328 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
338 <path d="M447.137,434.88 L 748.87,434.88 Q 763.87,434.88 763.87,419.88 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
339 <path d="M489.547,489.312 L 748.87,489.312 Q 763.87,489.312 763.87,474.312 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
340 <path d="M597.36,619.344 L 748.87,619.344 Q 763.87,619.344 763.87,604.344 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
341 <path d="M407.625,673.776 L 748.87,673.776 Q 763.87,673.776 763.87,658.776 L 763.87,155.608 L 763.87,140.608" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
342 </svg>
343 </div><br>
344
345 Used by:&nbsp;&nbsp; <a href='./sql-stmt.html'>sql-stmt</a><br></br>
346 References:&nbsp;&nbsp; <a href='./column-def.html'>column-def</a>&nbsp;&nbsp; <a href='./conflict-clause.html'>conflict-clause</a>&nbsp;&nbsp; <a href='./expr.html'>expr</a><br></br>
347 See also:&nbsp;&nbsp; <a href='../lang_altertable.html'>lang_altertable.html</a>
348 </div>
349
350
351