<html dir="LTR" xmlns="http://www.w3.org/1999/xhtml" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:MSHelp="http://msdn.microsoft.com/mshelp" xmlns:tool="http://www.microsoft.com/tooltip" xmlns:ndoc="urn:ndoc-preprocess">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=Windows-1252" />
<title>SQLite Query Syntax</title>
<link rel="stylesheet" type="text/css" href="../Include/ndoc.css" />
</head>
<body>
<div id="header">
<table width="100%" id="topTable">
<tr id="headerTableRow1">
<td align="left">
<span id="runningHeaderText">SQLite Query Syntax</span> </td>
</tr>
<tr id="headerTableRow2">
<td align="left">
<span id="nsrTitle">SQLite Language Reference Documentation</span>
</td>
</tr>
<tr id="headerTableRow3" style="display:none">
<td>
<a id="seeAlsoSectionLink" href="#seeAlsoToggle" onclick="OpenSection(seeAlsoToggle)">See Also</a>
<a id="exampleSectionLink" href="#codeExampleToggle" onclick="OpenSection(codeExampleToggle)">Example</a>
</td>
</tr>
</table>
<table width="100%" id="bottomTable" cellspacing="0" cellpadding="0" style="display:none">
<tr>
<td>
<span onclick="ExpandCollapseAll(toggleAllImage)" style="cursor:default;" onkeypress="ExpandCollapseAll_CheckKey(toggleAllImage)" tabindex="0">
<img ID="toggleAllImage" class="toggleAll" src="collall.gif" />
<label id="collapseAllLabel" for="toggleAllImage" style="display: none;">
Collapse All
</label>
<label id="expandAllLabel" for="toggleAllImage" style="display: none;">
Expand All
</label>
</span>
</td>
</tr>
</table>
</div>
<div id="mainSection">
<div id="mainBody">
<h1 class="heading">
SQL As Understood By System.Data.SQLite</h1>
<p>
The SQLite library understands most of the standard SQL language. But it does omit
some features while at the same time adding a few features of its own. This document
attempts to describe precisely what parts of the SQL language SQLite does and does
not support. A list of keywords is also provided. In all of the syntax diagrams
that follow, literal text is shown in bold blue. Non-terminal symbols are shown
in italic red. Operators that are part of the syntactic markup itself are shown
in black roman. This document is just an overview of the SQL syntax implemented
by SQLite.
</p>
<h4>
The SQLite core library implements the follow syntax:</h4>
<p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse">
<tr>
<td>
<a href="../Core/lang.html">
SQL As Understood By SQLite</a></td>
</tr>
</table>
</p>
<h4>
The System.Data.SQLite provider implements the follow additional syntax:</h4>
<p>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse">
<tr>
<td>
<a href="lang_types.html">
TYPES</a></td>
</tr>
</table>
</p>
<hr>
<div id="footer">
<p>
</p>
<p>
</p>
</div>
</div>
</div>
</body>
</html>