<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta charset="utf-8">
<meta name="generator" content="pdf2htmlEX">
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<link rel="stylesheet" href="https://static.pudn.com/base/css/base.min.css">
<link rel="stylesheet" href="https://static.pudn.com/base/css/fancy.min.css">
<link rel="stylesheet" href="https://static.pudn.com/prod/directory_preview_static/62763e37bc4cdc30ab11a45d/raw.css">
<script src="https://static.pudn.com/base/js/compatibility.min.js"></script>
<script src="https://static.pudn.com/base/js/pdf2htmlEX.min.js"></script>
<script>
try{
pdf2htmlEX.defaultViewer = new pdf2htmlEX.Viewer({});
}catch(e){}
</script>
<title></title>
</head>
<body>
<div id="sidebar" style="display: none">
<div id="outline">
</div>
</div>
<div id="pf1" class="pf w0 h0" data-page-no="1"><div class="pc pc1 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/62763e37bc4cdc30ab11a45d/bg1.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x1 h3 y2 ff1 fs0 fc0 sc0 ls0 ws0">ALTER TABLE</div><div class="t m0 x2 h4 y3 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=</span></div><div class="t m0 x3 h5 y4 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="_ _0"></span><span class="ff3 fc0">[<span class="ff2 fc1">database-name</span></span><span class="fs2"></span><span class="ff3 fc0">]</span><span class="ff2 fc1">table-name<span class="_ _1"></span></span><span class="ff2 fc1">alteration</span></div><div class="t m0 x4 h4 y5 ff2 fs1 fc1 sc0 ls0 ws0">alteration<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"><span class="_ _3"></span><span class="ff2 fc1">new-table-name</span></span></span></div><div class="t m0 x4 h4 y6 ff2 fs1 fc1 sc0 ls0 ws0">alteration<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>]<span class="ff4 fc2"></span></span>column-def</div><div class="t m0 x1 h6 y7 ff1 fs3 fc0 sc0 ls0 ws0">ATTACH DATABASE</div><div class="t m0 x2 h4 y8 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"><span class="_ _0"></span><span class="_ _3"></span><span class="ff3 fc0">[</span><span class="_ _0"></span><span class="_ _4"></span><span class="ff3 fc0">]</span><span class="ff2 fc1">database-filename</span><span class="_ _4"></span><span class="ff2 fc1">database-name</span></span></span></div><div class="t m0 x1 h6 y9 ff1 fs3 fc0 sc0 ls0 ws0">BEGIN TRANSACTION</div><div class="t m0 x2 h4 ya ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=</span></div><div class="t m0 x3 h7 yb ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _5"> </span><span class="ff3 fc0">[</span><span class="_ _5"> </span><span class="_ _5"> </span><span class="ff3 fs2 fc0">|</span><span class="_ _5"> </span><span class="_ _0"></span><span class="_ _6"> </span><span class="ff3 fs2 fc0">|</span><span class="_ _5"> </span><span class="_ _5"> </span><span class="ff3 fc0">]</span></div><div class="t m0 x3 h4 yc ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2"></span>[<span class="ff2 fc1">name</span>]]</div><div class="t m0 x2 h4 yd ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 ye ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 yf ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x1 h3 y10 ff1 fs0 fc0 sc0 ls0 ws0">comment</div><div class="t m0 x5 h4 y11 ff2 fs1 fc1 sc0 ls0 ws0">comment<span class="ff3 fc0">::=</span></div><div class="t m0 x6 h7 y12 ff2 fs1 fc1 sc0 ls0 ws0">SQL-comment<span class="ff4 fc2"><span class="ff3 fs2 fc0">|</span></span>C-comment</div><div class="t m0 x2 h4 y13 ff2 fs1 fc1 sc0 ls0 ws0">SQL-comment<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span></span>single-line</div><div class="t m0 x7 h4 y14 ff2 fs1 fc1 sc0 ls0 ws0">C-comment<span class="ff3 fc0">::=</span></div><div class="t m0 x6 h5 y15 ff4 fs1 fc2 sc0 ls0 ws0"><span class="fs2"></span><span class="ff2 fc1">multiple-lines</span><span class="ff3 fc0">[</span><span class="fs2"></span><span class="ff3 fc0">]</span></div><div class="t m0 x1 h6 y16 ff1 fs3 fc0 sc0 ls0 ws0">BEGIN TRANSACTION</div><div class="t m0 x2 h4 y17 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=</span></div><div class="t m0 x3 h7 y18 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _5"> </span><span class="ff3 fc0">[</span><span class="_ _5"> </span><span class="_ _5"> </span><span class="ff3 fs2 fc0">|</span><span class="_ _5"> </span><span class="_ _0"></span><span class="_ _6"> </span><span class="ff3 fs2 fc0">|</span><span class="_ _5"> </span><span class="_ _5"> </span><span class="ff3 fc0">]</span></div><div class="t m0 x3 h4 y19 ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2"></span>[<span class="ff2 fc1">name</span>]]</div><div class="t m0 x2 h4 y1a ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 y1b ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x2 h4 y1c ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span>[<span class="ff4 fc2"></span>[</span>name<span class="ff3 fc0">]]</span></div><div class="t m0 x1 h6 y1d ff1 fs3 fc0 sc0 ls0 ws0">COPY</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
</body>
</html>
<div id="pf2" class="pf w0 h0" data-page-no="2"><div class="pc pc2 w0 h0"><img class="bi x0 y0 w1 h1" alt="" src="https://static.pudn.com/prod/directory_preview_static/62763e37bc4cdc30ab11a45d/bg2.jpg"><div class="c x0 y1 w2 h2"><div class="t m0 x2 h4 y1e ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=</span></div><div class="t m0 x3 h5 y1f ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _7"> </span><span class="ff3 fc0">[</span><span class="_ _8"> </span><span class="_ _8"> </span><span class="ff2 fc1">conflict-algorithm</span><span class="_ _8"> </span><span class="ff3 fc0">]</span><span class="_ _8"> </span><span class="ff3 fc0">[<span class="ff2 fc1">database-name</span></span><span class="_ _8"> </span><span class="fs2"></span><span class="ff3 fc0">]</span><span class="_ _8"> </span><span class="ff2 fc1">table-name</span><span class="_ _8"> </span></div><div class="t m0 x3 h4 y20 ff2 fs1 fc1 sc0 ls0 ws0">filename</div><div class="t m0 x3 h4 y3 ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2"><span class="ff2 fc1">delim</span></span>]</div><div class="t m0 x1 h3 y21 ff1 fs0 fc0 sc0 ls0 ws0">CREATE INDEX</div><div class="t m0 x8 h4 y22 ff2 fs1 fc1 sc0 ls0 ws0">sql-statement<span class="ff3 fc0">::=</span></div><div class="t m0 x9 h5 y23 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="_ _9"></span><span class="ff3 fc0">[</span><span class="ff3 fc0">]</span><span class="_ _1"></span><span class="_ _9"></span><span class="ff3 fc0">[<span class="ff2 fc1">database-name</span></span><span class="_ _1"></span><span class="fs2"></span><span class="ff3 fc0">]</span><span class="_ _9"></span><span class="ff2 fc1">index-name</span></div><div class="t m0 x9 h7 y24 ff4 fs1 fc2 sc0 ls0 ws0"><span class="ff2 fc1">table-name</span><span class="fs2"></span><span class="ff2 fc1">column-name</span><span class="ff3 fc0">[<span class="_ _1"></span></span><span class="fs2"></span><span class="ff2 fc1">column-name<span class="ff3 fc0">]<span class="fs2">*</span></span></span><span class="fs2"></span></div><div class="t m0 x9 h4 y25 ff3 fs1 fc0 sc0 ls0 ws0">[<span class="ff4 fc2"><span class="ff2 fc1">conflict-algorithm</span></span>]</div><div class="t m0 x2 h4 y26 ff2 fs1 fc1 sc0 ls0 ws0">column-name<span class="ff3 fc0">::=</span></div><div class="t m0 x9 h7 y27 ff2 fs1 fc1 sc0 ls0 ws0">name<span class="ff4 fc2"><span class="ff3 fc0">[</span><span class="_ _4"></span><span class="ff2 fc1">collation-name<span class="ff3 fc0">]</span></span><span class="ff3 fc0">[</span><span class="_ _4"></span><span class="ff3 fs2 fc0">|</span><span class="_ _1"></span><span class="ff3 fc0">]</span></span></div><div class="t m0 x1 h8 y28 ff1 fs4 fc0 sc0 ls0 ws0">CREATE TABLE</div><div class="t m0 xa h4 y29 ff2 fs1 fc1 sc0 ls0 ws0">sql-command<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y2a ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="ff3 fc0">[</span><span class="_ _3"></span><span class="ff3 fs2 fc0">|</span><span class="_ _4"></span><span class="ff3 fc0">]</span><span class="_ _4"></span><span class="ff2 fc1">table-name</span><span class="fs2"></span></div><div class="t m0 xb h7 y2b ff4 fs1 fc2 sc0 ls0 ws0"> <span class="ff2 fc1">column-def</span><span class="ff3 fc0">[</span><span class="fs2"></span><span class="ff2 fc1">co<span class="_ _1"></span>lumn-def<span class="ff3 fc0">]<span class="fs2">*</span></span></span></div><div class="t m0 xb h7 y2c ff4 fs1 fc2 sc0 ls0 ws0"> <span class="ff3 fc0">[</span><span class="fs2"></span><span class="ff2 fc1">constraint<span class="ff3 fc0">]<span class="fs2">*</span></span></span></div><div class="t m0 xb h5 y2d ff4 fs2 fc2 sc0 ls0 ws0"></div><div class="t m0 xa h4 y2e ff2 fs1 fc1 sc0 ls0 ws0">sql-command<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y2f ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="_ _a"> </span><span class="ff3 fc0">[</span><span class="_ _b"></span><span class="ff3 fs2 fc0">|</span><span class="_ _c"> </span><span class="_ _3"></span><span class="ff3 fc0">]</span><span class="_ _c"> </span><span class="_ _0"></span><span class="_ _a"> </span><span class="ff3 fc0">[<span class="ff2 fc1">database-name</span></span><span class="fs2"></span><span class="ff3 fc0">]</span><span class="_ _a"> </span><span class="ff2 fc1">table-</span></div><div class="t m0 xb h4 y30 ff2 fs1 fc1 sc0 ls0 ws0">name<span class="ff4 fc2"><span class="_ _4"></span><span class="ff2 fc1">select-statement</span></span></div><div class="t m0 xc h4 y31 ff2 fs1 fc1 sc0 ls0 ws0">column-def<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y32 ff2 fs1 fc1 sc0 ls0 ws0">name<span class="ff4 fc2"><span class="ff3 fc0">[</span></span>type<span class="ff3 fc0">]<span class="ff4 fc2"></span>[[<span class="ff4 fc2"></span></span>name<span class="ff3 fc0">]<span class="ff4 fc2"></span></span>column-constraint<span class="ff3 fc0">]<span class="fs2">*</span></span></div><div class="t m0 xd h4 y33 ff2 fs1 fc1 sc0 ls0 ws0">type<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y34 ff2 fs1 fc1 sc0 ls0 ws0">typename<span class="ff4 fc2"><span class="ff3 fs2 fc0">|</span></span></div><div class="t m0 xb h7 y35 ff2 fs1 fc1 sc0 ls0 ws0">typename<span class="ff4 fc2"><span class="fs2"></span></span>number<span class="ff4 fc2"><span class="fs2"></span><span class="ff3 fs2 fc0">|</span></span></div><div class="t m0 xb h5 y36 ff2 fs1 fc1 sc0 ls0 ws0">typename<span class="ff4 fc2"><span class="fs2"></span></span>number<span class="ff4 fc2"><span class="fs2"></span></span>number<span class="ff4 fc2"><span class="_ _1"></span><span class="fs2"></span></span></div><div class="t m0 x2 h4 y37 ff2 fs1 fc1 sc0 ls0 ws0">column-constraint<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y38 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _3"></span><span class="_ _3"></span><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause</span><span class="ff3 fc0">]</span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h4 y39 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _3"></span><span class="_ _3"></span><span class="_ _3"></span><span class="ff3 fc0">[<span class="ff2 fc1">sort-or<span class="_ _3"></span>der<span class="ff3 fc0">]<span class="ff4 fc2"><span class="_ _1"></span></span>[<span class="ff4 fc2"></span></span>conflict-clause<span class="ff4 fc2"><span class="ff3 fc0">]</span><span class="_ _1"></span><span class="ff3 fc0">[</span><span class="_ _3"></span><span class="_ _1"></span><span class="ff3 fc0">]</span></span></span></span></div><div class="t m0 xb h7 y3a ff3 fs2 fc0 sc0 ls0 ws0">|</div><div class="t m0 xb h7 y3b ff4 fs1 fc2 sc0 ls0 ws0"><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause</span><span class="ff3 fc0">]</span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h7 y3c ff4 fs1 fc2 sc0 ls0 ws0"><span class="fs2"></span><span class="ff2 fc1">expr</span><span class="fs2"></span><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause</span><span class="ff3 fc0">]</span><span class="_ _1"></span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h7 y3d ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="_ _0"></span><span class="ff2 fc1">value</span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h4 y3e ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _0"></span><span class="_ _1"></span><span class="ff2 fc1">collation-name</span></div><div class="t m0 xe h4 y3f ff2 fs1 fc1 sc0 ls0 ws0">constraint<span class="ff3 fc0">::=</span></div><div class="t m0 xb h7 y40 ff4 fs1 fc2 sc0 ls0 ws0"><span class="_ _3"></span><span class="_ _3"></span><span class="_ _4"></span><span class="_ _1"></span><span class="fs2"></span><span class="ff2 fc1">column-list</span><span class="fs2"></span><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause</span><span class="_ _1"></span><span class="ff3 fc0">]</span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h7 y41 ff4 fs1 fc2 sc0 ls0 ws0"><span class="fs2"></span><span class="ff2 fc1">column-list</span><span class="fs2"></span><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause<span class="_ _1"></span></span><span class="ff3 fc0">]</span><span class="ff3 fs2 fc0">|</span></div><div class="t m0 xb h5 y42 ff4 fs1 fc2 sc0 ls0 ws0"><span class="fs2"></span><span class="ff2 fc1">expr</span><span class="fs2"></span><span class="ff3 fc0">[</span><span class="ff2 fc1">conflict-clause</span><span class="ff3 fc0">]</span></div><div class="t m0 x4 h4 y43 ff2 fs1 fc1 sc0 ls0 ws0">conflict-clause<span class="ff3 fc0">::=<span class="_ _2"> </span><span class="ff4 fc2"></span></span>conflict-algorithm</div></div></div><div class="pi" data-data='{"ctm":[1.611850,0.000000,0.000000,1.611850,0.000000,0.000000]}'></div></div>
