0.191/language/reserved.html

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    
    <title>7.2. Reserved Keywords &#8212; Presto 0.191 Documentation</title>
    
    <link rel="stylesheet" href="../_static/presto.css" type="text/css" />
    <link rel="stylesheet" href="../_static/pygments.css" type="text/css" />
    
    <script type="text/javascript">
      var DOCUMENTATION_OPTIONS = {
        URL_ROOT:    '../',
        VERSION:     '0.191',
        COLLAPSE_INDEX: false,
        FILE_SUFFIX: '.html',
        HAS_SOURCE:  true
      };
    </script>
    <script type="text/javascript" src="../_static/jquery.js"></script>
    <script type="text/javascript" src="../_static/underscore.js"></script>
    <script type="text/javascript" src="../_static/doctools.js"></script>
    <link rel="index" title="Index" href="../genindex.html" />
    <link rel="search" title="Search" href="../search.html" />
    <link rel="top" title="Presto 0.191 Documentation" href="../index.html" />
    <link rel="up" title="7. SQL Language" href="../language.html" />
    <link rel="next" title="8. SQL Statement Syntax" href="../sql.html" />
    <link rel="prev" title="7.1. Data Types" href="types.html" /> 
  </head>
  <body role="document">
<div class="header">
    <h1 class="heading"><a href="../index.html">
        <span>Presto 0.191 Documentation</span></a></h1>
    <h2 class="heading"><span>7.2. Reserved Keywords</span></h2>
</div>
<div class="topnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="types.html">7.1. Data Types</a>
    </span>
    <span class="right">
        <a href="../sql.html">8. SQL Statement Syntax</a> &raquo;
    </span>
</p>

</div>
<div class="content">
    
  <div class="section" id="reserved-keywords">
<h1>7.2. Reserved Keywords</h1>
<p>The following table lists all of the keywords that are reserved in Presto,
along with their status in the SQL standard. These reserved keywords must
be quoted (using double quotes) in order to be used as an identifier.</p>
<table border="1" class="docutils">
<colgroup>
<col width="54%" />
<col width="23%" />
<col width="23%" />
</colgroup>
<thead valign="bottom">
<tr class="row-odd"><th class="head">Keyword</th>
<th class="head">SQL:2016</th>
<th class="head">SQL-92</th>
</tr>
</thead>
<tbody valign="top">
<tr class="row-even"><td><code class="docutils literal"><span class="pre">ALTER</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">AND</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">AS</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">BETWEEN</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">BY</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">CASE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">CAST</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">CONSTRAINT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">CREATE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">CROSS</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">CUBE</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">CURRENT_DATE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">CURRENT_TIME</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">CURRENT_TIMESTAMP</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">DEALLOCATE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">DELETE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">DESCRIBE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">DISTINCT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">DROP</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">ELSE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">END</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">ESCAPE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">EXCEPT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">EXECUTE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">EXISTS</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">EXTRACT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">FALSE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">FOR</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">FROM</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">FULL</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">GROUP</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">GROUPING</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">HAVING</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">IN</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">INNER</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">INSERT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">INTERSECT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">INTO</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">IS</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">JOIN</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">LEFT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">LIKE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">LOCALTIME</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">LOCALTIMESTAMP</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">NATURAL</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">NORMALIZE</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">NOT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">NULL</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">ON</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">OR</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">ORDER</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">OUTER</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">PREPARE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">RECURSIVE</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">RIGHT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">ROLLUP</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">SELECT</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">TABLE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">THEN</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">TRUE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">UESCAPE</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">UNION</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">UNNEST</span></code></td>
<td>reserved</td>
<td>&nbsp;</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">USING</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">VALUES</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">WHEN</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-even"><td><code class="docutils literal"><span class="pre">WHERE</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
<tr class="row-odd"><td><code class="docutils literal"><span class="pre">WITH</span></code></td>
<td>reserved</td>
<td>reserved</td>
</tr>
</tbody>
</table>
</div>


</div>
<div class="bottomnav">
    
<p class="nav">
    <span class="left">
        &laquo; <a href="types.html">7.1. Data Types</a>
    </span>
    <span class="right">
        <a href="../sql.html">8. SQL Statement Syntax</a> &raquo;
    </span>
</p>

</div>

    <div class="footer" role="contentinfo">
    </div>
  </body>
</html>