sql-92.bnf.html

来自「sql 92的 bnf范式」· HTML 代码 · 共 505 行 · 第 1/5 页

</p><p><a name="schema name"> &nbsp; </a>
<a href="#xref-schema%20name"> &lt;schema name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; [  <a href="#catalog%20name">&lt;catalog name&gt;</a>  <a href="#period">&lt;period&gt;</a>  ]  <a href="#unqualified%20schema%20name">&lt;unqualified schema name&gt;</a>

</p><p><a name="catalog name"> &nbsp; </a>
<a href="#xref-catalog%20name"> &lt;catalog name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a name="identifier"> &nbsp; </a>
<a href="#xref-identifier"> &lt;identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; [  <a href="#introducer">&lt;introducer&gt;</a> <a href="#character%20set%20specification">&lt;character set specification&gt;</a>  ]  <a href="#actual%20identifier">&lt;actual identifier&gt;</a>

</p><p><a name="actual identifier"> &nbsp; </a>
<a href="#xref-actual%20identifier"> &lt;actual identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#regular%20identifier">&lt;regular identifier&gt;</a>  |  <a href="#delimited%20identifier">&lt;delimited identifier&gt;</a>

</p><p><a name="delimited identifier"> &nbsp; </a>
<a href="#xref-delimited%20identifier"> &lt;delimited identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#double%20quote">&lt;double quote&gt;</a>  <a href="#delimited%20identifier%20body">&lt;delimited identifier body&gt;</a>  <a href="#double%20quote">&lt;double quote&gt;</a>

</p><p><a name="delimited identifier body"> &nbsp; </a>
<a href="#xref-delimited%20identifier%20body"> &lt;delimited identifier body&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#delimited%20identifier%20part">&lt;delimited identifier part&gt;</a> ...

</p><p><a name="delimited identifier part"> &nbsp; </a>
<a href="#xref-delimited%20identifier%20part"> &lt;delimited identifier part&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#nondoublequote%20character">&lt;nondoublequote character&gt;</a>  |  <a href="#doublequote%20symbol">&lt;doublequote symbol&gt;</a>

</p><p><a name="nondoublequote character"> &nbsp; </a>
<a href="#xref-nondoublequote%20character"> &lt;nondoublequote character&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp;<font color="red"> !! See the syntax rules </font>

</p><p><a name="doublequote symbol"> &nbsp; </a>
<a href="#xref-doublequote%20symbol"> &lt;doublequote symbol&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#double%20quote">&lt;double quote&gt;</a> <a href="#double%20quote">&lt;double quote&gt;</a>

</p><p><a name="unqualified schema name"> &nbsp; </a>
<a href="#xref-unqualified%20schema%20name"> &lt;unqualified schema name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#identifier">&lt;identifier&gt;</a>

</p><p><a name="SQL language identifier"> &nbsp; </a>
<a href="#xref-SQL%20language%20identifier"> &lt;SQL language identifier&gt; </a>&nbsp;&nbsp;&nbsp;::=
<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="#SQL%20language%20identifier%20start">&lt;SQL language identifier start&gt;</a>  [  {  <a href="#underscore">&lt;underscore&gt;</a>  |  <a href="#SQL%20language%20identifier%20part">&lt;SQL language identifier part&gt;</a>  }...  ]
</p><p><a name="SQL language identifier start"> &nbsp; </a>
<a href="#xref-SQL%20language%20identifier%20start"> &lt;SQL language identifier start&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#simple%20Latin%20letter">&lt;simple Latin letter&gt;</a>

</p><p><a name="SQL language identifier part"> &nbsp; </a>
<a href="#xref-SQL%20language%20identifier%20part"> &lt;SQL language identifier part&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#simple%20Latin%20letter">&lt;simple Latin letter&gt;</a>  |  <a href="#digit">&lt;digit&gt;</a>

</p><p><a name="implementation-defined character repertoire name"> &nbsp; </a>
<a href="#xref-implementation-defined%20character%20repertoire%20name"> &lt;implementation-defined character repertoire name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#character%20set%20name">&lt;character set name&gt;</a>

</p><p><a name="user-defined character repertoire name"> &nbsp; </a>
<a href="#xref-user-defined%20character%20repertoire%20name"> &lt;user-defined character repertoire name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#character%20set%20name">&lt;character set name&gt;</a>

</p><p><a name="standard universal character form-of-use name"> &nbsp; </a>
<a href="#xref-standard%20universal%20character%20form-of-use%20name"> &lt;standard universal character form-of-use name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#character%20set%20name">&lt;character set name&gt;</a>

</p><p><a name="implementation-defined universal character form-of-use name"> &nbsp; </a>
<a href="#xref-implementation-defined%20universal%20character%20form-of-use%20name"> &lt;implementation-defined universal character form-of-use name&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#character%20set%20name">&lt;character set name&gt;</a>

</p><p><a name="date string"> &nbsp; </a>
<a href="#xref-date%20string"> &lt;date string&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a>  <a href="#date%20value">&lt;date value&gt;</a>  <a href="#quote">&lt;quote&gt;</a>

</p><p><a name="date value"> &nbsp; </a>
<a href="#xref-date%20value"> &lt;date value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#years%20value">&lt;years value&gt;</a>  <a href="#minus%20sign">&lt;minus sign&gt;</a>  <a href="#months%20value">&lt;months value&gt;</a>  <a href="#minus%20sign">&lt;minus sign&gt;</a>  <a href="#days%20value">&lt;days value&gt;</a>

</p><p><a name="years value"> &nbsp; </a>
<a href="#xref-years%20value"> &lt;years value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#datetime%20value">&lt;datetime value&gt;</a>

</p><p><a name="datetime value"> &nbsp; </a>
<a href="#xref-datetime%20value"> &lt;datetime value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>

</p><p><a name="months value"> &nbsp; </a>
<a href="#xref-months%20value"> &lt;months value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#datetime%20value">&lt;datetime value&gt;</a>

</p><p><a name="days value"> &nbsp; </a>
<a href="#xref-days%20value"> &lt;days value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#datetime%20value">&lt;datetime value&gt;</a>

</p><p><a name="time string"> &nbsp; </a>
<a href="#xref-time%20string"> &lt;time string&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a>  <a href="#time%20value">&lt;time value&gt;</a>  [  <a href="#time%20zone%20interval">&lt;time zone interval&gt;</a>  ]  <a href="#quote">&lt;quote&gt;</a>

</p><p><a name="time value"> &nbsp; </a>
<a href="#xref-time%20value"> &lt;time value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#hours%20value">&lt;hours value&gt;</a>  <a href="#colon">&lt;colon&gt;</a>  <a href="#minutes%20value">&lt;minutes value&gt;</a>  <a href="#colon">&lt;colon&gt;</a>  <a href="#seconds%20value">&lt;seconds value&gt;</a>

</p><p><a name="hours value"> &nbsp; </a>
<a href="#xref-hours%20value"> &lt;hours value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#datetime%20value">&lt;datetime value&gt;</a>

</p><p><a name="minutes value"> &nbsp; </a>
<a href="#xref-minutes%20value"> &lt;minutes value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#datetime%20value">&lt;datetime value&gt;</a>

</p><p><a name="seconds value"> &nbsp; </a>
<a href="#xref-seconds%20value"> &lt;seconds value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#seconds%20integer%20value">&lt;seconds integer value&gt;</a>  [  <a href="#period">&lt;period&gt;</a>  [  <a href="#seconds%20fraction">&lt;seconds fraction&gt;</a>  ]  ]

</p><p><a name="seconds integer value"> &nbsp; </a>
<a href="#xref-seconds%20integer%20value"> &lt;seconds integer value&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>

</p><p><a name="seconds fraction"> &nbsp; </a>
<a href="#xref-seconds%20fraction"> &lt;seconds fraction&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#unsigned%20integer">&lt;unsigned integer&gt;</a>

</p><p><a name="time zone interval"> &nbsp; </a>
<a href="#xref-time%20zone%20interval"> &lt;time zone interval&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#sign">&lt;sign&gt;</a>  <a href="#hours%20value">&lt;hours value&gt;</a>  <a href="#colon">&lt;colon&gt;</a>  <a href="#minutes%20value">&lt;minutes value&gt;</a>

</p><p><a name="timestamp string"> &nbsp; </a>
<a href="#xref-timestamp%20string"> &lt;timestamp string&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a>  <a href="#date%20value">&lt;date value&gt;</a>  <a href="#space">&lt;space&gt;</a>  <a href="#time%20value">&lt;time value&gt;</a>  [  <a href="#time%20zone%20interval">&lt;time zone interval&gt;</a>  ]  <a href="#quote">&lt;quote&gt;</a>

</p><p><a name="interval string"> &nbsp; </a>
<a href="#xref-interval%20string"> &lt;interval string&gt; </a>&nbsp;&nbsp;&nbsp;::=&nbsp;&nbsp; <a href="#quote">&lt;quote&gt;</a>  {  <a href="#year-month%20literal">&lt;year-month literal&gt;</a>  |  <a href="#day-time%20literal">&lt;day-time literal&gt;</a>  }  <a href="#quote">&lt;quote&gt;</a>

</p><p><a name="year-month literal"> &nbsp; </a>