diff options
Diffstat (limited to 'www/syntax/alter-table-stmt.html')
-rw-r--r-- | www/syntax/alter-table-stmt.html | 249 |
1 files changed, 249 insertions, 0 deletions
diff --git a/www/syntax/alter-table-stmt.html b/www/syntax/alter-table-stmt.html new file mode 100644 index 0000000..b1f5bd9 --- /dev/null +++ b/www/syntax/alter-table-stmt.html @@ -0,0 +1,249 @@ +<!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: alter-table-stmt</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'>alter-table-stmt</h1> +<div class='imgcontainer'> +<div style="max-width:754px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 754.521 320.904"> +<circle cx="5" cy="32" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="37,32 26,37 26,28" style="fill:rgb(0,0,0)"/> +<path d="M9,32L31,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M37,32L59,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M74,47L113,47A15 15 0 0 0 129 32A15 15 0 0 0 113 17L74,17A15 15 0 0 0 59 32A15 15 0 0 0 74 47Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="94" y="32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ALTER</text> +<polygon points="165,32 153,37 153,28" style="fill:rgb(0,0,0)"/> +<path d="M129,32L159,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M180,47L219,47A15 15 0 0 0 234 32A15 15 0 0 0 219 17L180,17A15 15 0 0 0 165 32A15 15 0 0 0 180 47Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="199" y="32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TABLE</text> +<polygon points="251,32 240,37 240,28" style="fill:rgb(0,0,0)"/> +<path d="M234,32L245,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="287,32 276,37 276,28" style="fill:rgb(0,0,0)"/> +<path d="M251,32L281,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M302,47L399,47A15 15 0 0 0 414 32A15 15 0 0 0 399 17L302,17A15 15 0 0 0 287 32A15 15 0 0 0 302 47Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="351" y="32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text> +<polygon points="436,32 425,37 425,28" style="fill:rgb(0,0,0)"/> +<path d="M414,32L431,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M452,47A15 15 0 0 0 467 32A15 15 0 0 0 452 17A15 15 0 0 0 436 32A15 15 0 0 0 452 47Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="452" y="32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">.</text> +<polygon points="503,32 491,37 491,28" style="fill:rgb(0,0,0)"/> +<path d="M467,32L497,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M518,47L593,47A15 15 0 0 0 608 32A15 15 0 0 0 593 17L518,17A15 15 0 0 0 503 32A15 15 0 0 0 518 47Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="555" y="32" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text> +<polygon points="376,6 364,10 364,2" style="fill:rgb(0,0,0)"/> +<path d="M251,32 L 260,32 Q 268,32 268,19 Q 268,6 283,6 L 355,6 L 370,6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M376,6 L 461,6 Q 476,6 476,19 Q 476,32 489,32 L 503,32" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="626,56 622,45 630,45" style="fill:rgb(0,0,0)"/> +<path d="M608,32 L 617,32 Q 626,32 626,41 L 626,51" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="351,81 362,76 362,85" style="fill:rgb(0,0,0)"/> +<path d="M626,56 L 626,68 Q 626,81 611,81 L 371,81 L 356,81" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M351,81 L 20,81 Q 5,81 5,88 L 5,96" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="41,126 30,130 30,122" style="fill:rgb(0,0,0)"/> +<path d="M5,96 L 5,111 Q 5,126 20,126 L 20,126 L 36,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M56,141L117,141A15 15 0 0 0 132 126A15 15 0 0 0 117 111L56,111A15 15 0 0 0 41 126A15 15 0 0 0 56 141Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="87" y="126" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">RENAME</text> +<polygon points="150,126 139,130 139,122" style="fill:rgb(0,0,0)"/> +<path d="M132,126L144,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M165,141L171,141A15 15 0 0 0 186 126A15 15 0 0 0 171 111L165,111A15 15 0 0 0 150 126A15 15 0 0 0 165 141Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="168" y="126" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TO</text> +<polygon points="204,126 193,130 193,122" style="fill:rgb(0,0,0)"/> +<path d="M186,126L198,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M219,141L334,141A15 15 0 0 0 349 126A15 15 0 0 0 334 111L219,111A15 15 0 0 0 204 126A15 15 0 0 0 219 141Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="277" y="126" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">new-table-name</text> +<polygon points="41,171 30,176 30,167" style="fill:rgb(0,0,0)"/> +<path d="M5,96 L 5,156 Q 5,171 20,171 L 21,171 L 36,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M56,186L117,186A15 15 0 0 0 132 171A15 15 0 0 0 117 156L56,156A15 15 0 0 0 41 171A15 15 0 0 0 56 186Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="87" y="171" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">RENAME</text> +<polygon points="149,171 138,176 138,167" style="fill:rgb(0,0,0)"/> +<path d="M132,171L143,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="185,171 174,176 174,167" style="fill:rgb(0,0,0)"/> +<path d="M149,171L179,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M200,186L263,186A15 15 0 0 0 278 171A15 15 0 0 0 263 156L200,156A15 15 0 0 0 185 171A15 15 0 0 0 200 186Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="232" y="171" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text> +<polygon points="314,171 303,176 303,167" style="fill:rgb(0,0,0)"/> +<path d="M278,171L308,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M329,186L423,186A15 15 0 0 0 439 171A15 15 0 0 0 423 156L329,156A15 15 0 0 0 314 171A15 15 0 0 0 329 186Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="376" y="171" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text> +<polygon points="457,171 445,176 445,167" style="fill:rgb(0,0,0)"/> +<path d="M439,171L451,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M472,186L477,186A15 15 0 0 0 492 171A15 15 0 0 0 477 156L472,156A15 15 0 0 0 457 171A15 15 0 0 0 472 186Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="475" y="171" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TO</text> +<polygon points="510,171 499,176 499,167" style="fill:rgb(0,0,0)"/> +<path d="M492,171L505,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M526,186L660,186A15 15 0 0 0 675 171A15 15 0 0 0 660 156L526,156A15 15 0 0 0 510 171A15 15 0 0 0 526 186Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="593" y="171" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">new-column-name</text> +<polygon points="692,171 680,176 680,167" style="fill:rgb(0,0,0)"/> +<path d="M675,171L686,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="745,126 733,130 733,122" style="fill:rgb(0,0,0)"/> +<path d="M692,171 L 700,171 Q 709,171 709,156 L 709,141 Q 709,126 724,126 L 724,126 L 739,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<circle cx="748" cy="126" r="3.6" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="745,126 733,130 733,122" style="fill:rgb(0,0,0)"/> +<path d="M349,126L739,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="232,198 220,202 220,193" style="fill:rgb(0,0,0)"/> +<path d="M149,171 L 158,171 Q 166,171 166,184 Q 166,198 181,198 L 211,198 L 226,198" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="314,171 303,176 303,167" style="fill:rgb(0,0,0)"/> +<path d="M232,198 L 272,198 Q 287,198 287,184 Q 287,171 298,171 L 308,171" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="41,232 30,236 30,227" style="fill:rgb(0,0,0)"/> +<path d="M5,96 L 5,217 Q 5,232 20,232 L 21,232 L 36,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M56,247L76,247A15 15 0 0 0 91 232A15 15 0 0 0 76 217L56,217A15 15 0 0 0 41 232A15 15 0 0 0 56 247Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="66" y="232" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">ADD</text> +<polygon points="108,232 97,236 97,227" style="fill:rgb(0,0,0)"/> +<path d="M91,232L102,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="144,232 133,236 133,227" style="fill:rgb(0,0,0)"/> +<path d="M108,232L138,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M159,247L222,247A15 15 0 0 0 237 232A15 15 0 0 0 222 217L159,217A15 15 0 0 0 144 232A15 15 0 0 0 159 247Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="191" y="232" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text> +<polygon points="273,232 262,236 262,227" style="fill:rgb(0,0,0)"/> +<path d="M237,232L267,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M273,247L378,247L378,217L273,217Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="326" y="232" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-def</text> +<polygon points="692,232 680,236 680,227" style="fill:rgb(0,0,0)"/> +<path d="M378,232L686,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="191,258 179,262 179,254" style="fill:rgb(0,0,0)"/> +<path d="M108,232 L 117,232 Q 125,232 125,245 Q 125,258 140,258 L 170,258 L 185,258" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="273,232 262,236 262,227" style="fill:rgb(0,0,0)"/> +<path d="M191,258 L 231,258 Q 246,258 246,245 Q 246,232 257,232 L 267,232" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="745,126 733,130 733,122" style="fill:rgb(0,0,0)"/> +<path d="M692,232 L 700,232 Q 709,232 709,217 L 709,141 Q 709,126 724,126 L 724,126 L 739,126" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="41,288 30,292 30,283" style="fill:rgb(0,0,0)"/> +<path d="M5,217 L 5,273 Q 5,288 20,288 L 21,288 L 36,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M56,303L87,303A15 15 0 0 0 103 288A15 15 0 0 0 87 273L56,273A15 15 0 0 0 41 288A15 15 0 0 0 56 303Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="72" y="288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">DROP</text> +<polygon points="120,288 108,292 108,283" style="fill:rgb(0,0,0)"/> +<path d="M103,288L114,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="156,288 144,292 144,283" style="fill:rgb(0,0,0)"/> +<path d="M120,288L150,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M171,303L234,303A15 15 0 0 0 249 288A15 15 0 0 0 234 273L171,273A15 15 0 0 0 156 288A15 15 0 0 0 171 303Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="202" y="288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">COLUMN</text> +<polygon points="285,288 273,292 273,283" style="fill:rgb(0,0,0)"/> +<path d="M249,288L279,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M300,303L394,303A15 15 0 0 0 409 288A15 15 0 0 0 394 273L300,273A15 15 0 0 0 285 288A15 15 0 0 0 300 303Z" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<text x="347" y="288" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">column-name</text> +<polygon points="692,288 680,292 680,283" style="fill:rgb(0,0,0)"/> +<path d="M409,288L686,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M692,288 L 700,288 Q 709,288 709,273 L 709,232 L 709,217" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<polygon points="202,314 191,318 191,310" style="fill:rgb(0,0,0)"/> +<path d="M120,288 L 127,288 Q 135,288 135,301 Q 135,314 150,314 L 181,314 L 196,314" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +<path d="M202,314 L 245,314 Q 260,314 260,301 Q 260,288 268,288 L 275,288" style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" /> +</svg> +</div><br> + +Used by: <a href='./sql-stmt.html'>sql-stmt</a><br></br> +References: <a href='./column-def.html'>column-def</a><br></br> +See also: <a href='../lang_altertable.html'>lang_altertable.html</a> +</div> + + + |