1 files changed, 244 insertions, 0 deletions
diff --git a/www/lang_createvtab.html b/www/lang_createvtab.html
new file mode 100644
index 0000000..6247425
--- /dev/null
+++ b/www/lang_createvtab.html
@@ -0,0 +1,244 @@
+<!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>CREATE VIRTUAL TABLE</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>
+<div class=fancy>
+<div class=nosearch>
+<div class="fancy_title">
+CREATE VIRTUAL TABLE
+</div>
+</div>
+
+
+
+
+
+<p><b><a href="syntax/create-virtual-table-stmt.html">create-virtual-table-stmt:</a></b>
+<button id='x1641' onclick='hideorshow("x1641","x1642")'>hide</button></p>
+ <div id='x1642' class='imgcontainer'>
+ <div style="max-width:624px"><svg xmlns='http://www.w3.org/2000/svg' class="pikchr" viewBox="0 0 624.096 259.848">
+<circle cx="5" cy="17" r="3.6"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="32,17 20,21 20,12" style="fill:rgb(0,0,0)"/>
+<path d="M9,17L26,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M47,32L100,32A15 15 0 0 0 116 17A15 15 0 0 0 100 2L47,2A15 15 0 0 0 32 17A15 15 0 0 0 47 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="74" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">CREATE</text>
+<polygon points="139,17 127,21 127,12" style="fill:rgb(0,0,0)"/>
+<path d="M116,17L133,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M154,32L213,32A15 15 0 0 0 228 17A15 15 0 0 0 213 2L154,2A15 15 0 0 0 139 17A15 15 0 0 0 154 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="183" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">VIRTUAL</text>
+<polygon points="251,17 240,21 240,12" style="fill:rgb(0,0,0)"/>
+<path d="M228,17L246,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M266,32L306,32A15 15 0 0 0 321 17A15 15 0 0 0 306 2L266,2A15 15 0 0 0 251 17A15 15 0 0 0 266 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="286" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">TABLE</text>
+<polygon points="357,17 345,21 345,12" style="fill:rgb(0,0,0)"/>
+<path d="M321,17L351,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M372,32A15 15 0 0 0 387 17A15 15 0 0 0 372 2A15 15 0 0 0 357 17A15 15 0 0 0 372 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="372" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">IF</text>
+<polygon points="410,17 399,21 399,12" style="fill:rgb(0,0,0)"/>
+<path d="M387,17L404,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M425,32L445,32A15 15 0 0 0 461 17A15 15 0 0 0 445 2L425,2A15 15 0 0 0 410 17A15 15 0 0 0 425 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="435" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">NOT</text>
+<polygon points="484,17 472,21 472,12" style="fill:rgb(0,0,0)"/>
+<path d="M461,17L478,17"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M499,32L543,32A15 15 0 0 0 558 17A15 15 0 0 0 543 2L499,2A15 15 0 0 0 484 17A15 15 0 0 0 499 32Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="521" y="17" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">EXISTS</text>
+<path d="M47,108L143,108A15 15 0 0 0 159 92A15 15 0 0 0 143 77L47,77A15 15 0 0 0 32 92A15 15 0 0 0 47 108Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="95" y="92" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">schema-name</text>
+<polygon points="182,92 170,97 170,88" style="fill:rgb(0,0,0)"/>
+<path d="M159,92L176,92"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M197,108A15 15 0 0 0 212 92A15 15 0 0 0 197 77A15 15 0 0 0 182 92A15 15 0 0 0 197 108Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="197" y="92" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">.</text>
+<polygon points="248,92 236,97 236,88" style="fill:rgb(0,0,0)"/>
+<path d="M212,92L242,92"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M263,108L338,108A15 15 0 0 0 353 92A15 15 0 0 0 338 77L263,77A15 15 0 0 0 248 92A15 15 0 0 0 263 108Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="300" y="92" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">table-name</text>
+<path d="M47,219L86,219A15 15 0 0 0 101 204A15 15 0 0 0 86 189L47,189A15 15 0 0 0 32 204A15 15 0 0 0 47 219Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="67" y="204" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">USING</text>
+<polygon points="124,204 113,209 113,200" style="fill:rgb(0,0,0)"/>
+<path d="M101,204L118,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M139,219L234,219A15 15 0 0 0 249 204A15 15 0 0 0 234 189L139,189A15 15 0 0 0 124 204A15 15 0 0 0 139 219Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="187" y="204" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">module-name</text>
+<polygon points="285,204 274,209 274,200" style="fill:rgb(0,0,0)"/>
+<path d="M249,204L279,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M300,219A15 15 0 0 0 315 204A15 15 0 0 0 300 189A15 15 0 0 0 285 204A15 15 0 0 0 300 219Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="300" y="204" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">(</text>
+<polygon points="351,204 340,209 340,200" style="fill:rgb(0,0,0)"/>
+<path d="M315,204L346,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M366,219L497,219A15 15 0 0 0 512 204A15 15 0 0 0 497 189L366,189A15 15 0 0 0 351 204A15 15 0 0 0 366 219Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="432" y="204" text-anchor="middle" fill="rgb(0,0,0)" dominant-baseline="central">module-argument</text>
+<polygon points="548,204 536,209 536,200" style="fill:rgb(0,0,0)"/>
+<path d="M512,204L542,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M563,219A15 15 0 0 0 578 204A15 15 0 0 0 563 189A15 15 0 0 0 548 204A15 15 0 0 0 563 219Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="563" y="204" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">)</text>
+<polygon points="614,204 603,209 603,200" style="fill:rgb(0,0,0)"/>
+<path d="M578,204L608,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<circle cx="618" cy="204" r="3.6"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M432,257A15 15 0 0 0 447 242A15 15 0 0 0 432 227A15 15 0 0 0 417 242A15 15 0 0 0 432 257Z"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<text x="432" y="242" text-anchor="middle" font-weight="bold" fill="rgb(0,0,0)" dominant-baseline="central">,</text>
+<polygon points="447,242 458,238 458,246" style="fill:rgb(0,0,0)"/>
+<path d="M512,204 L 519,204 Q 527,204 527,219 L 527,227 Q 527,242 512,242 L 468,242 L 453,242"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M417,242 L 343,242 Q 328,242 328,227 L 328,219 Q 328,204 336,204 L 343,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="432,180 420,184 420,176" style="fill:rgb(0,0,0)"/>
+<path d="M249,204 L 257,204 Q 264,204 264,192 Q 264,180 279,180 L 411,180 L 426,180"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M432,180 L 576,180 Q 591,180 591,192 Q 591,204 599,204 L 606,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="187,153 198,149 198,157" style="fill:rgb(0,0,0)"/>
+<path d="M353,92 L 361,92 Q 368,92 368,107 L 368,138 Q 368,153 353,153 L 207,153 L 192,153"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="32,204 20,209 20,200" style="fill:rgb(0,0,0)"/>
+<path d="M187,153 L 20,153 Q 5,153 5,168 L 5,189 Q 5,204 16,204 L 26,204"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="429,62 441,58 441,66" style="fill:rgb(0,0,0)"/>
+<path d="M558,17 L 566,17 Q 573,17 573,32 L 573,47 Q 573,62 558,62 L 450,62 L 435,62"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="32,92 20,97 20,88" style="fill:rgb(0,0,0)"/>
+<path d="M429,62 L 20,62 Q 5,62 5,77 L 5,77 Q 5,92 16,92 L 26,92"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="336,47 332,35 340,35" style="fill:rgb(0,0,0)"/>
+<path d="M321,17 L 328,17 Q 336,17 336,29 L 336,41"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M336,47 L 336,54 Q 336,62 328,62 L 321,62"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<polygon points="95,123 84,127 84,118" style="fill:rgb(0,0,0)"/>
+<path d="M5,77 L 5,108 Q 5,123 20,123 L 74,123 L 89,123"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+<path d="M95,123 L 210,123 Q 225,123 225,108 L 225,107 Q 225,92 231,92 L 236,92"  style="fill:none;stroke-width:2.16;stroke:rgb(0,0,0);" />
+</svg>
+</div>
+</div>
+
+
+<p>A <a href="vtab.html">virtual table</a> is an interface to an external storage or computation
+engine that appears to be a table but does not actually store information
+in the database file.</p>
+
+<p>In general, you can do anything with a <a href="vtab.html">virtual table</a> that can be done
+with an ordinary table, except that you cannot create indices or triggers on a
+virtual table.  Some virtual table implementations might impose additional
+restrictions.  For example, many virtual tables are read-only.</p>
+
+<p>The <span class='yyterm'>module-name</span> is the name of an object that implements
+the virtual table.  The <span class='yyterm'>module-name</span> must be registered with
+the SQLite database connection using
+<a href="c3ref/create_module.html">sqlite3_create_module()</a> or <a href="c3ref/create_module.html">sqlite3_create_module_v2()</a>
+prior to issuing the CREATE VIRTUAL TABLE statement.
+The module takes zero or more comma-separated arguments.
+The arguments can be just about any text as long as it has balanced
+parentheses.  The argument syntax is sufficiently general that the
+arguments can be made to appear as <a href="lang_createtable.html#tablecoldef">column definitions</a> in a traditional
+<a href="lang_createtable.html">CREATE TABLE</a> statement.  
+SQLite passes the module arguments directly
+to the <a href="vtab.html#xcreate">xCreate</a> and <a href="vtab.html#xconnect">xConnect</a> methods of the module implementation
+without any interpretation.  It is the responsibility
+of the module implementation to parse and interpret its own arguments.</p>
+
+<p>A virtual table is destroyed using the ordinary
+<a href="lang_droptable.html">DROP TABLE</a> statement.  There is no
+DROP VIRTUAL TABLE statement.</p>
+<p align="center"><small><i>This page last modified on  <a href="https://sqlite.org/docsrc/honeypot" id="mtimelink"  data-href="https://sqlite.org/docsrc/finfo/pages/lang_createvtab.in?m=73c535b61b90923f9">2020-02-10 20:33:26</a> UTC </small></i></p>
+