summaryrefslogtreecommitdiffstats
path: root/www/syntax/alter-table-stmt.html
diff options
context:
space:
mode:
authorDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-05 17:28:19 +0000
committerDaniel Baumann <daniel.baumann@progress-linux.org>2024-05-05 17:28:19 +0000
commit18657a960e125336f704ea058e25c27bd3900dcb (patch)
tree17b438b680ed45a996d7b59951e6aa34023783f2 /www/syntax/alter-table-stmt.html
parentInitial commit. (diff)
downloadsqlite3-18657a960e125336f704ea058e25c27bd3900dcb.tar.xz
sqlite3-18657a960e125336f704ea058e25c27bd3900dcb.zip
Adding upstream version 3.40.1.upstream/3.40.1upstream
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'www/syntax/alter-table-stmt.html')
-rw-r--r--www/syntax/alter-table-stmt.html249
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:&nbsp;&nbsp; <a href='./sql-stmt.html'>sql-stmt</a><br></br>
+References:&nbsp;&nbsp; <a href='./column-def.html'>column-def</a><br></br>
+See also:&nbsp;&nbsp; <a href='../lang_altertable.html'>lang_altertable.html</a>
+</div>
+
+
+
generated by cgit v1.2.3 (git 2.39.1) at 2024-12-25 03:22:38 +0000