<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<html><head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title>Syntax Diagrams For SQLite</title>
<style type="text/css">
body {
margin: auto;
font-family: Verdana, sans-serif;
padding: 8px 1%;
}
a { color: #044a64 }
a:visited { color: #734559 }
.logo { position:absolute; margin:3px; }
.tagline {
float:right;
text-align:right;
font-style:italic;
width:300px;
margin:12px;
margin-top:58px;
}
.menubar {
clear: both;
border-radius: 8px;
background: #044a64;
padding: 0px;
margin: 0px;
cell-spacing: 0px;
}
.toolbar {
text-align: center;
line-height: 1.6em;
margin: 0;
padding: 0px 8px;
}
.toolbar a { color: white; text-decoration: none; padding: 6px 12px; }
.toolbar a:visited { color: white; }
.toolbar a:hover { color: #044a64; background: white; }
.content { margin: 5%; }
.content dt { font-weight:bold; }
.content dd { margin-bottom: 25px; margin-left:20%; }
.content ul { padding:0px; padding-left: 15px; margin:0px; }
/* Things for "fancyformat" documents start here. */
.fancy img+p {font-style:italic}
.fancy .codeblock i { color: darkblue; }
.fancy h1,.fancy h2,.fancy h3,.fancy h4 {font-weight:normal;color:#044a64}
.fancy h2 { margin-left: 10px }
.fancy h3 { margin-left: 20px }
.fancy h4 { margin-left: 30px }
.fancy th {white-space:nowrap;text-align:left;border-bottom:solid 1px #444}
.fancy th, .fancy td {padding: 0.2em 1ex; vertical-align:top}
.fancy #toc a { color: darkblue ; text-decoration: none }
.fancy .todo { color: #AA3333 ; font-style : italic }
.fancy .todo:before { content: 'TODO:' }
.fancy p.todo { border: solid #AA3333 1px; padding: 1ex }
.fancy img { display:block; }
.fancy :link:hover, .fancy :visited:hover { background: wheat }
.fancy p,.fancy ul,.fancy ol { margin: 1em 5ex }
.fancy li p { margin: 1em 0 }
/* End of "fancyformat" specific rules. */
</style>
</head>
<body>
<div><!-- container div to satisfy validator -->
<a href="index.html">
<img class="logo" src="images/sqlite370_banner.gif" alt="SQLite Logo"
border="0"></a>
<div><!-- IE hack to prevent disappearing logo--></div>
<div class="tagline">Small. Fast. Reliable.<br>Choose any three.</div>
<table width=100% class="menubar"><tr>
<td width=100%>
<div class="toolbar">
<a href="about.html">About</a>
<a href="sitemap.html">Sitemap</a>
<a href="docs.html">Documentation</a>
<a href="download.html">Download</a>
<a href="copyright.html">License</a>
<a href="news.html">News</a>
<a href="support.html">Support</a>
</div>
<script>
gMsg = "Search SQLite Docs..."
function entersearch() {
var q = document.getElementById("q");
if( q.value == gMsg ) { q.value = "" }
q.style.color = "black"
q.style.fontStyle = "normal"
}
function leavesearch() {
var q = document.getElementById("q");
if( q.value == "" ) {
q.value = gMsg
q.style.color = "#044a64"
q.style.fontStyle = "italic"
}
}
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;
}
</script>
<td>
<div style="padding:0 1em 0px 0;white-space:nowrap">
<form name=f method="GET" action="https://www.sqlite.org/search">
<input id=q name=q type=text
onfocus="entersearch()" onblur="leavesearch()" style="width:24ex;padding:1px 1ex; border:solid white 1px; font-size:0.9em ; font-style:italic;color:#044a64;" value="Search SQLite Docs...">
<input type=submit value="Go" style="border:solid white 1px;background-color:#044a64;color:white;font-size:0.9em;padding:0 1ex">
</form>
</div>
</table>
<div class=startsearch></div>
<h1 align=center>Syntax Diagrams For SQLite</h1>
<a name="sql-stmt-list"></a>
<h4>sql-stmt-list:</h4><blockquote>
<img src="images/syntax/sql-stmt-list.gif"></img><br></br><br></br>
References: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang.html">lang.html</a>
</blockquote>
<a name="sql-stmt"></a>
<h4>sql-stmt:</h4><blockquote>
<img src="images/syntax/sql-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt-list">sql-stmt-list</a><br></br>
References: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#analyze-stmt">analyze-stmt</a> <a href="#attach-stmt">attach-stmt</a> <a href="#begin-stmt">begin-stmt</a> <a href="#commit-stmt">commit-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#create-virtual-table-stmt">create-virtual-table-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#detach-stmt">detach-stmt</a> <a href="#drop-index-stmt">drop-index-stmt</a> <a href="#drop-table-stmt">drop-table-stmt</a> <a href="#drop-trigger-stmt">drop-trigger-stmt</a> <a href="#drop-view-stmt">drop-view-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#pragma-stmt">pragma-stmt</a> <a href="#reindex-stmt">reindex-stmt</a> <a href="#release-stmt">release-stmt</a> <a href="#rollback-stmt">rollback-stmt</a> <a href="#savepoint-stmt">savepoint-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a> <a href="#vacuum-stmt">vacuum-stmt</a><br></br>
See also: <a href="lang.html">lang.html</a> <a href="lang_explain.html">lang_explain.html</a>
</blockquote>
<a name="alter-table-stmt"></a>
<h4>alter-table-stmt:</h4><blockquote>
<img src="images/syntax/alter-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#column-def">column-def</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a>
</blockquote>
<a name="analyze-stmt"></a>
<h4>analyze-stmt:</h4><blockquote>
<img src="images/syntax/analyze-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_analyze.html">lang_analyze.html</a>
</blockquote>
<a name="attach-stmt"></a>
<h4>attach-stmt:</h4><blockquote>
<img src="images/syntax/attach-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_attach.html">lang_attach.html</a>
</blockquote>
<a name="begin-stmt"></a>
<h4>begin-stmt:</h4><blockquote>
<img src="images/syntax/begin-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<a name="commit-stmt"></a>
<h4>commit-stmt:</h4><blockquote>
<img src="images/syntax/commit-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<a name="rollback-stmt"></a>
<h4>rollback-stmt:</h4><blockquote>
<img src="images/syntax/rollback-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a> <a href="lang_transaction.html">lang_transaction.html</a>
</blockquote>
<a name="savepoint-stmt"></a>
<h4>savepoint-stmt:</h4><blockquote>
<img src="images/syntax/savepoint-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
</blockquote>
<a name="release-stmt"></a>
<h4>release-stmt:</h4><blockquote>
<img src="images/syntax/release-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_savepoint.html">lang_savepoint.html</a>
</blockquote>
<a name="create-index-stmt"></a>
<h4>create-index-stmt:</h4><blockquote>
<img src="images/syntax/create-index-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#indexed-column">indexed-column</a><br></br>
See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="indexed-column"></a>
<h4>indexed-column:</h4><blockquote>
<img src="images/syntax/indexed-column.gif"></img><br></br>
Used by: <a href="#create-index-stmt">create-index-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="create-table-stmt"></a>
<h4>create-table-stmt:</h4><blockquote>
<img src="images/syntax/create-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#column-def">column-def</a> <a href="#select-stmt">select-stmt</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_createtable.html">lang_createtable.html</a>
</blockquote>
<a name="column-def"></a>
<h4>column-def:</h4><blockquote>
<img src="images/syntax/column-def.gif"></img><br></br>
Used by: <a href="#alter-table-stmt">alter-table-stmt</a> <a href="#create-table-stmt">create-table-stmt</a><br></br>
References: <a href="#column-constraint">column-constraint</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<a name="type-name"></a>
<h4>type-name:</h4><blockquote>
<img src="images/syntax/type-name.gif"></img><br></br>
Used by: <a href="#column-def">column-def</a> <a href="#expr">expr</a><br></br>
References: <a href="#signed-number">signed-number</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="column-constraint"></a>
<h4>column-constraint:</h4><blockquote>
<img src="images/syntax/column-constraint.gif"></img><br></br>
Used by: <a href="#column-def">column-def</a><br></br>
References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#literal-value">literal-value</a> <a href="#signed-number">signed-number</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<a name="signed-number"></a>
<h4>signed-number:</h4><blockquote>
<img src="images/syntax/signed-number.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#pragma-value">pragma-value</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a> <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<a name="table-constraint"></a>
<h4>table-constraint:</h4><blockquote>
<img src="images/syntax/table-constraint.gif"></img><br></br>
Used by: <a href="#create-table-stmt">create-table-stmt</a><br></br>
References: <a href="#conflict-clause">conflict-clause</a> <a href="#expr">expr</a> <a href="#foreign-key-clause">foreign-key-clause</a> <a href="#indexed-column">indexed-column</a><br></br>
See also: <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#primkeyconst">lang_createtable.html#primkeyconst</a> <a href="lang_createtable.html#tablecoldef">lang_createtable.html#tablecoldef</a>
</blockquote>
<a name="foreign-key-clause"></a>
<h4>foreign-key-clause:</h4><blockquote>
<img src="images/syntax/foreign-key-clause.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_createtable.html">lang_createtable.html</a>
</blockquote>
<a name="conflict-clause"></a>
<h4>conflict-clause:</h4><blockquote>
<img src="images/syntax/conflict-clause.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#table-constraint">table-constraint</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_conflict.html">lang_conflict.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtable.html#notnullconst">lang_createtable.html#notnullconst</a>
</blockquote>
<a name="create-trigger-stmt"></a>
<h4>create-trigger-stmt:</h4><blockquote>
<img src="images/syntax/create-trigger-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#delete-stmt">delete-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#update-stmt">update-stmt</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a>
</blockquote>
<a name="create-view-stmt"></a>
<h4>create-view-stmt:</h4><blockquote>
<img src="images/syntax/create-view-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_createview.html">lang_createview.html</a>
</blockquote>
<a name="create-virtual-table-stmt"></a>
<h4>create-virtual-table-stmt:</h4><blockquote>
<img src="images/syntax/create-virtual-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_createvtab.html">lang_createvtab.html</a>
</blockquote>
<a name="with-clause"></a>
<h4>with-clause:</h4><blockquote>
<img src="images/syntax/with-clause.gif"></img><br></br>
Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#insert-stmt">insert-stmt</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#cte-table-name">cte-table-name</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a>
</blockquote>
<a name="cte-table-name"></a>
<h4>cte-table-name:</h4><blockquote>
<img src="images/syntax/cte-table-name.gif"></img><br></br>
Used by: <a href="#recursive-cte">recursive-cte</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a>
</blockquote>
<a name="recursive-cte"></a>
<h4>recursive-cte:</h4><blockquote>
<img src="images/syntax/recursive-cte.gif"></img><br></br><br></br>
References: <a href="#cte-table-name">cte-table-name</a><br></br>
See also: <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a>
</blockquote>
<a name="common-table-expression"></a>
<h4>common-table-expression:</h4><blockquote>
<img src="images/syntax/common-table-expression.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br>
References: <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="delete-stmt"></a>
<h4>delete-stmt:</h4><blockquote>
<img src="images/syntax/delete-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a>
</blockquote>
<a name="delete-stmt-limited"></a>
<h4>delete-stmt-limited:</h4><blockquote>
<img src="images/syntax/delete-stmt-limited.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_delete.html">lang_delete.html</a>
</blockquote>
<a name="detach-stmt"></a>
<h4>detach-stmt:</h4><blockquote>
<img src="images/syntax/detach-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_detach.html">lang_detach.html</a>
</blockquote>
<a name="drop-index-stmt"></a>
<h4>drop-index-stmt:</h4><blockquote>
<img src="images/syntax/drop-index-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_dropindex.html">lang_dropindex.html</a>
</blockquote>
<a name="drop-table-stmt"></a>
<h4>drop-table-stmt:</h4><blockquote>
<img src="images/syntax/drop-table-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_droptable.html">lang_droptable.html</a>
</blockquote>
<a name="drop-trigger-stmt"></a>
<h4>drop-trigger-stmt:</h4><blockquote>
<img src="images/syntax/drop-trigger-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_droptrigger.html">lang_droptrigger.html</a>
</blockquote>
<a name="drop-view-stmt"></a>
<h4>drop-view-stmt:</h4><blockquote>
<img src="images/syntax/drop-view-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_dropview.html">lang_dropview.html</a>
</blockquote>
<a name="expr"></a>
<h4>expr:</h4><blockquote>
<img src="images/syntax/expr.gif"></img><br></br>
Used by: <a href="#attach-stmt">attach-stmt</a> <a href="#column-constraint">column-constraint</a> <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#create-index-stmt">create-index-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#insert-stmt">insert-stmt</a> <a href="#join-constraint">join-constraint</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#table-constraint">table-constraint</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#literal-value">literal-value</a> <a href="#raise-function">raise-function</a> <a href="#select-stmt">select-stmt</a> <a href="#type-name">type-name</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="raise-function"></a>
<h4>raise-function:</h4><blockquote>
<img src="images/syntax/raise-function.gif"></img><br></br>
Used by: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createtrigger.html#raise">lang_createtrigger.html#raise</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="literal-value"></a>
<h4>literal-value:</h4><blockquote>
<img src="images/syntax/literal-value.gif"></img><br></br>
Used by: <a href="#column-constraint">column-constraint</a> <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="numeric-literal"></a>
<h4>numeric-literal:</h4><blockquote>
<img src="images/syntax/numeric-literal.gif"></img><br></br><br></br>
See also: <a href="lang_expr.html#litvalue">lang_expr.html#litvalue</a>
</blockquote>
<a name="insert-stmt"></a>
<h4>insert-stmt:</h4><blockquote>
<img src="images/syntax/insert-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#select-stmt">select-stmt</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_insert.html">lang_insert.html</a>
</blockquote>
<a name="pragma-stmt"></a>
<h4>pragma-stmt:</h4><blockquote>
<img src="images/syntax/pragma-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#pragma-value">pragma-value</a><br></br>
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<a name="pragma-value"></a>
<h4>pragma-value:</h4><blockquote>
<img src="images/syntax/pragma-value.gif"></img><br></br>
Used by: <a href="#pragma-stmt">pragma-stmt</a><br></br>
References: <a href="#signed-number">signed-number</a><br></br>
See also: <a href="pragma.html#syntax">pragma.html#syntax</a>
</blockquote>
<a name="reindex-stmt"></a>
<h4>reindex-stmt:</h4><blockquote>
<img src="images/syntax/reindex-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_reindex.html">lang_reindex.html</a>
</blockquote>
<a name="select-stmt"></a>
<h4>select-stmt:</h4><blockquote>
<img src="images/syntax/select-stmt.gif"></img><br></br>
Used by: <a href="#common-table-expression">common-table-expression</a> <a href="#create-table-stmt">create-table-stmt</a> <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#create-view-stmt">create-view-stmt</a> <a href="#expr">expr</a> <a href="#insert-stmt">insert-stmt</a> <a href="#sql-stmt">sql-stmt</a> <a href="#table-or-subquery">table-or-subquery</a> <a href="#with-clause">with-clause</a><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#ordering-term">ordering-term</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="join-clause"></a>
<h4>join-clause:</h4><blockquote>
<img src="images/syntax/join-clause.gif"></img><br></br>
Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
References: <a href="#join-constraint">join-constraint</a> <a href="#join-operator">join-operator</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="select-core"></a>
<h4>select-core:</h4><blockquote>
<img src="images/syntax/select-core.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#join-clause">join-clause</a> <a href="#result-column">result-column</a> <a href="#table-or-subquery">table-or-subquery</a><br></br>
See also: <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a>
</blockquote>
<a name="factored-select-stmt"></a>
<h4>factored-select-stmt:</h4><blockquote>
<img src="images/syntax/factored-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#compound-operator">compound-operator</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html">lang_select.html</a>
</blockquote>
<a name="simple-select-stmt"></a>
<h4>simple-select-stmt:</h4><blockquote>
<img src="images/syntax/simple-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a>
</blockquote>
<a name="compound-select-stmt"></a>
<h4>compound-select-stmt:</h4><blockquote>
<img src="images/syntax/compound-select-stmt.gif"></img><br></br><br></br>
References: <a href="#common-table-expression">common-table-expression</a> <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#select-core">select-core</a><br></br>
See also: <a href="lang_select.html#compound">lang_select.html#compound</a>
</blockquote>
<a name="table-or-subquery"></a>
<h4>table-or-subquery:</h4><blockquote>
<img src="images/syntax/table-or-subquery.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a> <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br>
References: <a href="#join-clause">join-clause</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="result-column"></a>
<h4>result-column:</h4><blockquote>
<img src="images/syntax/result-column.gif"></img><br></br>
Used by: <a href="#select-core">select-core</a> <a href="#select-stmt">select-stmt</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="join-operator"></a>
<h4>join-operator:</h4><blockquote>
<img src="images/syntax/join-operator.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="join-constraint"></a>
<h4>join-constraint:</h4><blockquote>
<img src="images/syntax/join-constraint.gif"></img><br></br>
Used by: <a href="#join-clause">join-clause</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#fromclause">lang_select.html#fromclause</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="ordering-term"></a>
<h4>ordering-term:</h4><blockquote>
<img src="images/syntax/ordering-term.gif"></img><br></br>
Used by: <a href="#compound-select-stmt">compound-select-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a> <a href="#simple-select-stmt">simple-select-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
References: <a href="#expr">expr</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="compound-operator"></a>
<h4>compound-operator:</h4><blockquote>
<img src="images/syntax/compound-operator.gif"></img><br></br>
Used by: <a href="#factored-select-stmt">factored-select-stmt</a> <a href="#select-stmt">select-stmt</a><br></br>
See also: <a href="lang_altertable.html">lang_altertable.html</a> <a href="lang_attach.html">lang_attach.html</a> <a href="lang_createindex.html">lang_createindex.html</a> <a href="lang_createtable.html">lang_createtable.html</a> <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_createview.html">lang_createview.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_expr.html">lang_expr.html</a> <a href="lang_insert.html">lang_insert.html</a> <a href="lang_select.html">lang_select.html</a> <a href="lang_select.html#compound">lang_select.html#compound</a> <a href="lang_select.html#simpleselect">lang_select.html#simpleselect</a> <a href="lang_update.html">lang_update.html</a> <a href="lang_with.html">lang_with.html</a> <a href="lang_with.html#recursivecte">lang_with.html#recursivecte</a> <a href="partialindex.html">partialindex.html</a>
</blockquote>
<a name="update-stmt"></a>
<h4>update-stmt:</h4><blockquote>
<img src="images/syntax/update-stmt.gif"></img><br></br>
Used by: <a href="#create-trigger-stmt">create-trigger-stmt</a> <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_update.html">lang_update.html</a>
</blockquote>
<a name="update-stmt-limited"></a>
<h4>update-stmt-limited:</h4><blockquote>
<img src="images/syntax/update-stmt-limited.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
References: <a href="#expr">expr</a> <a href="#ordering-term">ordering-term</a> <a href="#qualified-table-name">qualified-table-name</a> <a href="#with-clause">with-clause</a><br></br>
See also: <a href="lang_update.html">lang_update.html</a>
</blockquote>
<a name="qualified-table-name"></a>
<h4>qualified-table-name:</h4><blockquote>
<img src="images/syntax/qualified-table-name.gif"></img><br></br>
Used by: <a href="#delete-stmt">delete-stmt</a> <a href="#delete-stmt-limited">delete-stmt-limited</a> <a href="#update-stmt">update-stmt</a> <a href="#update-stmt-limited">update-stmt-limited</a><br></br>
See also: <a href="lang_createtrigger.html">lang_createtrigger.html</a> <a href="lang_delete.html">lang_delete.html</a> <a href="lang_indexedby.html">lang_indexedby.html</a> <a href="lang_update.html">lang_update.html</a>
</blockquote>
<a name="vacuum-stmt"></a>
<h4>vacuum-stmt:</h4><blockquote>
<img src="images/syntax/vacuum-stmt.gif"></img><br></br>
Used by: <a href="#sql-stmt">sql-stmt</a><br></br>
See also: <a href="lang_vacuum.html">lang_vacuum.html</a>
</blockquote>
<a name="comment-syntax"></a>
<h4>comment-syntax:</h4><blockquote>
<img src="images/syntax/comment-syntax.gif"></img><br></br><br></br>
See also: <a href="lang_comment.html">lang_comment.html</a>
</blockquote>
