首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Materialize
/
doc
/
user
/
layouts
/
partials
/
sql-grammar
/
create-source-sql-server.svg

create-source-sql-server.svg 11 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243 
  1. <svg xmlns="http://www.w3.org/2000/svg" width="667" height="871">
    2. 

  2.    <polygon points="9 17 1 13 1 21"/>
    3. 

  3.    <polygon points="17 17 9 13 9 21"/>
    4. 

  4.    <rect x="31" y="3" width="140" height="32" rx="10"/>
    5. 

  5.    <rect x="29"
    6. 

  6.          y="1"
    7. 

  7.          width="140"
    8. 

  8.          height="32"
    9. 

  9.          class="terminal"
    10. 

  10.          rx="10"/>
    11. 

  11.    <text class="terminal" x="39" y="21">CREATE SOURCE</text>
    12. 

  12.    <rect x="211" y="35" width="120" height="32" rx="10"/>
    13. 

  13.    <rect x="209"
    14. 

  14.          y="33"
    15. 

  15.          width="120"
    16. 

  16.          height="32"
    17. 

  17.          class="terminal"
    18. 

  18.          rx="10"/>
    19. 

  19.    <text class="terminal" x="219" y="53">IF NOT EXISTS</text>
    20. 

  20.    <rect x="371" y="3" width="82" height="32"/>
    21. 

  21.    <rect x="369" y="1" width="82" height="32" class="nonterminal"/>
    22. 

  22.    <text class="nonterminal" x="379" y="21">src_name</text>
    23. 

  23.    <rect x="115" y="133" width="104" height="32" rx="10"/>
    24. 

  24.    <rect x="113"
    25. 

  25.          y="131"
    26. 

  26.          width="104"
    27. 

  27.          height="32"
    28. 

  28.          class="terminal"
    29. 

  29.          rx="10"/>
    30. 

  30.    <text class="terminal" x="123" y="151">IN CLUSTER</text>
    31. 

  31.    <rect x="239" y="133" width="108" height="32"/>
    32. 

  32.    <rect x="237" y="131" width="108" height="32" class="nonterminal"/>
    33. 

  33.    <text class="nonterminal" x="247" y="151">cluster_name</text>
    34. 

  34.    <rect x="387" y="101" width="60" height="32" rx="10"/>
    35. 

  35.    <rect x="385"
    36. 

  36.          y="99"
    37. 

  37.          width="60"
    38. 

  38.          height="32"
    39. 

  39.          class="terminal"
    40. 

  40.          rx="10"/>
    41. 

  41.    <text class="terminal" x="395" y="119">FROM</text>
    42. 

  42.    <rect x="467" y="101" width="108" height="32" rx="10"/>
    43. 

  43.    <rect x="465"
    44. 

  44.          y="99"
    45. 

  45.          width="108"
    46. 

  46.          height="32"
    47. 

  47.          class="terminal"
    48. 

  48.          rx="10"/>
    49. 

  49.    <text class="terminal" x="475" y="119">SQL SERVER</text>
    50. 

  50.    <rect x="199" y="199" width="116" height="32" rx="10"/>
    51. 

  51.    <rect x="197"
    52. 

  52.          y="197"
    53. 

  53.          width="116"
    54. 

  54.          height="32"
    55. 

  55.          class="terminal"
    56. 

  56.          rx="10"/>
    57. 

  57.    <text class="terminal" x="207" y="217">CONNECTION</text>
    58. 

  58.    <rect x="335" y="199" width="136" height="32"/>
    59. 

  59.    <rect x="333" y="197" width="136" height="32" class="nonterminal"/>
    60. 

  60.    <text class="nonterminal" x="343" y="217">connection_name</text>
    61. 

  61.    <rect x="94" y="309" width="26" height="32" rx="10"/>
    62. 

  62.    <rect x="92"
    63. 

  63.          y="307"
    64. 

  64.          width="26"
    65. 

  65.          height="32"
    66. 

  66.          class="terminal"
    67. 

  67.          rx="10"/>
    68. 

  68.    <text class="terminal" x="102" y="327">(</text>
    69. 

  69.    <rect x="140" y="309" width="134" height="32" rx="10"/>
    70. 

  70.    <rect x="138"
    71. 

  71.          y="307"
    72. 

  72.          width="134"
    73. 

  73.          height="32"
    74. 

  74.          class="terminal"
    75. 

  75.          rx="10"/>
    76. 

  76.    <text class="terminal" x="148" y="327">TEXT COLUMNS</text>
    77. 

  77.    <rect x="314" y="309" width="26" height="32" rx="10"/>
    78. 

  78.    <rect x="312"
    79. 

  79.          y="307"
    80. 

  80.          width="26"
    81. 

  81.          height="32"
    82. 

  82.          class="terminal"
    83. 

  83.          rx="10"/>
    84. 

  84.    <text class="terminal" x="322" y="327">(</text>
    85. 

  85.    <rect x="380" y="309" width="110" height="32"/>
    86. 

  86.    <rect x="378" y="307" width="110" height="32" class="nonterminal"/>
    87. 

  87.    <text class="nonterminal" x="388" y="327">column_name</text>
    88. 

  88.    <rect x="380" y="265" width="24" height="32" rx="10"/>
    89. 

  89.    <rect x="378"
    90. 

  90.          y="263"
    91. 

  91.          width="24"
    92. 

  92.          height="32"
    93. 

  93.          class="terminal"
    94. 

  94.          rx="10"/>
    95. 

  95.    <text class="terminal" x="388" y="283">,</text>
    96. 

  96.    <rect x="530" y="309" width="26" height="32" rx="10"/>
    97. 

  97.    <rect x="528"
    98. 

  98.          y="307"
    99. 

  99.          width="26"
    100. 

  100.          height="32"
    101. 

  101.          class="terminal"
    102. 

  102.          rx="10"/>
    103. 

  103.    <text class="terminal" x="538" y="327">)</text>
    104. 

  104.    <rect x="58" y="451" width="24" height="32" rx="10"/>
    105. 

  105.    <rect x="56"
    106. 

  106.          y="449"
    107. 

  107.          width="24"
    108. 

  108.          height="32"
    109. 

  109.          class="terminal"
    110. 

  110.          rx="10"/>
    111. 

  111.    <text class="terminal" x="66" y="469">,</text>
    112. 

  112.    <rect x="102" y="451" width="162" height="32" rx="10"/>
    113. 

  113.    <rect x="100"
    114. 

  114.          y="449"
    115. 

  115.          width="162"
    116. 

  116.          height="32"
    117. 

  117.          class="terminal"
    118. 

  118.          rx="10"/>
    119. 

  119.    <text class="terminal" x="110" y="469">EXCLUDE COLUMNS</text>
    120. 

  120.    <rect x="304" y="451" width="26" height="32" rx="10"/>
    121. 

  121.    <rect x="302"
    122. 

  122.          y="449"
    123. 

  123.          width="26"
    124. 

  124.          height="32"
    125. 

  125.          class="terminal"
    126. 

  126.          rx="10"/>
    127. 

  127.    <text class="terminal" x="312" y="469">(</text>
    128. 

  128.    <rect x="370" y="451" width="110" height="32"/>
    129. 

  129.    <rect x="368" y="449" width="110" height="32" class="nonterminal"/>
    130. 

  130.    <text class="nonterminal" x="378" y="469">column_name</text>
    131. 

  131.    <rect x="370" y="407" width="24" height="32" rx="10"/>
    132. 

  132.    <rect x="368"
    133. 

  133.          y="405"
    134. 

  134.          width="24"
    135. 

  135.          height="32"
    136. 

  136.          class="terminal"
    137. 

  137.          rx="10"/>
    138. 

  138.    <text class="terminal" x="378" y="425">,</text>
    139. 

  139.    <rect x="520" y="451" width="26" height="32" rx="10"/>
    140. 

  140.    <rect x="518"
    141. 

  141.          y="449"
    142. 

  142.          width="26"
    143. 

  143.          height="32"
    144. 

  144.          class="terminal"
    145. 

  145.          rx="10"/>
    146. 

  146.    <text class="terminal" x="528" y="469">)</text>
    147. 

  147.    <rect x="586" y="451" width="26" height="32" rx="10"/>
    148. 

  148.    <rect x="584"
    149. 

  149.          y="449"
    150. 

  150.          width="26"
    151. 

  151.          height="32"
    152. 

  152.          class="terminal"
    153. 

  153.          rx="10"/>
    154. 

  154.    <text class="terminal" x="594" y="469">)</text>
    155. 

  155.    <rect x="45" y="549" width="138" height="32" rx="10"/>
    156. 

  156.    <rect x="43"
    157. 

  157.          y="547"
    158. 

  158.          width="138"
    159. 

  159.          height="32"
    160. 

  160.          class="terminal"
    161. 

  161.          rx="10"/>
    162. 

  162.    <text class="terminal" x="53" y="567">FOR ALL TABLES</text>
    163. 

  163.    <rect x="45" y="637" width="106" height="32" rx="10"/>
    164. 

  164.    <rect x="43"
    165. 

  165.          y="635"
    166. 

  166.          width="106"
    167. 

  167.          height="32"
    168. 

  168.          class="terminal"
    169. 

  169.          rx="10"/>
    170. 

  170.    <text class="terminal" x="53" y="655">FOR TABLES</text>
    171. 

  171.    <rect x="171" y="637" width="26" height="32" rx="10"/>
    172. 

  172.    <rect x="169"
    173. 

  173.          y="635"
    174. 

  174.          width="26"
    175. 

  175.          height="32"
    176. 

  176.          class="terminal"
    177. 

  177.          rx="10"/>
    178. 

  178.    <text class="terminal" x="179" y="655">(</text>
    179. 

  179.    <rect x="237" y="637" width="96" height="32"/>
    180. 

  180.    <rect x="235" y="635" width="96" height="32" class="nonterminal"/>
    181. 

  181.    <text class="nonterminal" x="245" y="655">table_name</text>
    182. 

  182.    <rect x="373" y="669" width="40" height="32" rx="10"/>
    183. 

  183.    <rect x="371"
    184. 

  184.          y="667"
    185. 

  185.          width="40"
    186. 

  186.          height="32"
    187. 

  187.          class="terminal"
    188. 

  188.          rx="10"/>
    189. 

  189.    <text class="terminal" x="381" y="687">AS</text>
    190. 

  190.    <rect x="433" y="669" width="106" height="32"/>
    191. 

  191.    <rect x="431" y="667" width="106" height="32" class="nonterminal"/>
    192. 

  192.    <text class="nonterminal" x="441" y="687">subsrc_name</text>
    193. 

  193.    <rect x="237" y="593" width="24" height="32" rx="10"/>
    194. 

  194.    <rect x="235"
    195. 

  195.          y="591"
    196. 

  196.          width="24"
    197. 

  197.          height="32"
    198. 

  198.          class="terminal"
    199. 

  199.          rx="10"/>
    200. 

  200.    <text class="terminal" x="245" y="611">,</text>
    201. 

  201.    <rect x="599" y="637" width="26" height="32" rx="10"/>
    202. 

  202.    <rect x="597"
    203. 

  203.          y="635"
    204. 

  204.          width="26"
    205. 

  205.          height="32"
    206. 

  206.          class="terminal"
    207. 

  207.          rx="10"/>
    208. 

  208.    <text class="terminal" x="607" y="655">)</text>
    209. 

  209.    <rect x="101" y="751" width="76" height="32" rx="10"/>
    210. 

  210.    <rect x="99"
    211. 

  211.          y="749"
    212. 

  212.          width="76"
    213. 

  213.          height="32"
    214. 

  214.          class="terminal"
    215. 

  215.          rx="10"/>
    216. 

  216.    <text class="terminal" x="109" y="769">EXPOSE</text>
    217. 

  217.    <rect x="197" y="751" width="96" height="32" rx="10"/>
    218. 

  218.    <rect x="195"
    219. 

  219.          y="749"
    220. 

  220.          width="96"
    221. 

  221.          height="32"
    222. 

  222.          class="terminal"
    223. 

  223.          rx="10"/>
    224. 

  224.    <text class="terminal" x="205" y="769">PROGRESS</text>
    225. 

  225.    <rect x="313" y="751" width="40" height="32" rx="10"/>
    226. 

  226.    <rect x="311"
    227. 

  227.          y="749"
    228. 

  228.          width="40"
    229. 

  229.          height="32"
    230. 

  230.          class="terminal"
    231. 

  231.          rx="10"/>
    232. 

  232.    <text class="terminal" x="321" y="769">AS</text>
    233. 

  233.    <rect x="373" y="751" width="196" height="32"/>
    234. 

  234.    <rect x="371" y="749" width="196" height="32" class="nonterminal"/>
    235. 

  235.    <text class="nonterminal" x="381" y="769">progress_subsource_name</text>
    236. 

  236.    <rect x="517" y="837" width="102" height="32"/>
    237. 

  237.    <rect x="515" y="835" width="102" height="32" class="nonterminal"/>
    238. 

  238.    <text class="nonterminal" x="525" y="855">with_options</text>
    239. 

  239.    <path class="line"
    240. 

  240.          d="m17 17 h2 m0 0 h10 m140 0 h10 m20 0 h10 m0 0 h130 m-160 0 h20 m140 0 h20 m-180 0 q10 0 10 10 m160 0 q0 -10 10 -10 m-170 10 v12 m160 0 v-12 m-160 12 q0 10 10 10 m140 0 q10 0 10 -10 m-150 10 h10 m120 0 h10 m20 -32 h10 m82 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-402 98 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h242 m-272 0 h20 m252 0 h20 m-292 0 q10 0 10 10 m272 0 q0 -10 10 -10 m-282 10 v12 m272 0 v-12 m-272 12 q0 10 10 10 m252 0 q10 0 10 -10 m-262 10 h10 m104 0 h10 m0 0 h10 m108 0 h10 m20 -32 h10 m60 0 h10 m0 0 h10 m108 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-420 98 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m116 0 h10 m0 0 h10 m136 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-441 110 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m26 0 h10 m0 0 h10 m134 0 h10 m20 0 h10 m26 0 h10 m20 0 h10 m110 0 h10 m-150 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m130 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-130 0 h10 m24 0 h10 m0 0 h86 m20 44 h10 m26 0 h10 m-282 0 h20 m262 0 h20 m-302 0 q10 0 10 10 m282 0 q0 -10 10 -10 m-292 10 v14 m282 0 v-14 m-282 14 q0 10 10 10 m262 0 q10 0 10 -10 m-272 10 h10 m0 0 h252 m-502 -34 h20 m502 0 h20 m-542 0 q10 0 10 10 m522 0 q0 -10 10 -10 m-532 10 v30 m522 0 v-30 m-522 30 q0 10 10 10 m502 0 q10 0 10 -10 m-512 10 h10 m0 0 h492 m22 -50 l2 0 m2 0 l2 0 m2 0 l2 0 m-602 142 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m24 0 h10 m0 0 h10 m162 0 h10 m20 0 h10 m26 0 h10 m20 0 h10 m110 0 h10 m-150 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m130 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-130 0 h10 m24 0 h10 m0 0 h86 m20 44 h10 m26 0 h10 m-282 0 h20 m262 0 h20 m-302 0 q10 0 10 10 m282 0 q0 -10 10 -10 m-292 10 v14 m282 0 v-14 m-282 14 q0 10 10 10 m262 0 q10 0 10 -10 m-272 10 h10 m0 0 h252 m20 -34 h10 m26 0 h10 m-594 0 h20 m574 0 h20 m-614 0 q10 0 10 10 m594 0 q0 -10 10 -10 m-604 10 v30 m594 0 v-30 m-594 30 q0 10 10 10 m574 0 q10 0 10 -10 m-584 10 h10 m0 0 h564 m22 -50 l2 0 m2 0 l2 0 m2 0 l2 0 m-651 98 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m138 0 h10 m0 0 h442 m-620 0 h20 m600 0 h20 m-640 0 q10 0 10 10 m620 0 q0 -10 10 -10 m-630 10 v68 m620 0 v-68 m-620 68 q0 10 10 10 m600 0 q10 0 10 -10 m-610 10 h10 m106 0 h10 m0 0 h10 m26 0 h10 m20 0 h10 m96 0 h10 m20 0 h10 m0 0 h176 m-206 0 h20 m186 0 h20 m-226 0 q10 0 10 10 m206 0 q0 -10 10 -10 m-216 10 v12 m206 0 v-12 m-206 12 q0 10 10 10 m186 0 q10 0 10 -10 m-196 10 h10 m40 0 h10 m0 0 h10 m106 0 h10 m-342 -32 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m342 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-342 0 h10 m24 0 h10 m0 0 h298 m20 44 h10 m26 0 h10 m22 -88 l2 0 m2 0 l2 0 m2 0 l2 0 m-608 170 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h478 m-508 0 h20 m488 0 h20 m-528 0 q10 0 10 10 m508 0 q0 -10 10 -10 m-518 10 v12 m508 0 v-12 m-508 12 q0 10 10 10 m488 0 q10 0 10 -10 m-498 10 h10 m76 0 h10 m0 0 h10 m96 0 h10 m0 0 h10 m40 0 h10 m0 0 h10 m196 0 h10 m22 -32 l2 0 m2 0 l2 0 m2 0 l2 0 m-136 86 l2 0 m2 0 l2 0 m2 0 l2 0 m22 0 h10 m0 0 h112 m-142 0 h20 m122 0 h20 m-162 0 q10 0 10 10 m142 0 q0 -10 10 -10 m-152 10 v12 m142 0 v-12 m-142 12 q0 10 10 10 m122 0 q10 0 10 -10 m-132 10 h10 m102 0 h10 m23 -32 h-3"/>
    241. 

  241.    <polygon points="657 819 665 815 665 823"/>
    242. 

  242.    <polygon points="657 819 649 815 649 823"/>
    243. 

  243. </svg>
    244.