Materialize/doc/user/layouts/partials/sql-grammar/create-view.svg

<svg xmlns="http://www.w3.org/2000/svg" width="597" height="283">
   <polygon points="9 17 1 13 1 21"/>
   <polygon points="17 17 9 13 9 21"/>
   <rect x="31" y="3" width="76" height="32" rx="10"/>
   <rect x="29"
         y="1"
         width="76"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="39" y="21">CREATE</text>
   <rect x="167" y="35" width="60" height="32" rx="10"/>
   <rect x="165"
         y="33"
         width="60"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="175" y="53">TEMP</text>
   <rect x="167" y="79" width="110" height="32" rx="10"/>
   <rect x="165"
         y="77"
         width="110"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="175" y="97">TEMPORARY</text>
   <rect x="317" y="3" width="58" height="32" rx="10"/>
   <rect x="315"
         y="1"
         width="58"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="325" y="21">VIEW</text>
   <rect x="415" y="35" width="120" height="32" rx="10"/>
   <rect x="413"
         y="33"
         width="120"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="423" y="53">IF NOT EXISTS</text>
   <rect x="147" y="123" width="108" height="32" rx="10"/>
   <rect x="145"
         y="121"
         width="108"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="155" y="141">OR REPLACE</text>
   <rect x="275" y="123" width="58" height="32" rx="10"/>
   <rect x="273"
         y="121"
         width="58"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="283" y="141">VIEW</text>
   <rect x="31" y="233" width="92" height="32"/>
   <rect x="29" y="231" width="92" height="32" class="nonterminal"/>
   <text class="nonterminal" x="39" y="251">view_name</text>
   <rect x="163" y="233" width="26" height="32" rx="10"/>
   <rect x="161"
         y="231"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="171" y="251">(</text>
   <rect x="229" y="233" width="78" height="32"/>
   <rect x="227" y="231" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="237" y="251">col_ident</text>
   <rect x="229" y="189" width="24" height="32" rx="10"/>
   <rect x="227"
         y="187"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="237" y="207">,</text>
   <rect x="347" y="233" width="26" height="32" rx="10"/>
   <rect x="345"
         y="231"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="355" y="251">)</text>
   <rect x="413" y="233" width="40" height="32" rx="10"/>
   <rect x="411"
         y="231"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="421" y="251">AS</text>
   <rect x="473" y="233" width="96" height="32"/>
   <rect x="471" y="231" width="96" height="32" class="nonterminal"/>
   <text class="nonterminal" x="481" y="251">select_stmt</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m76 0 h10 m40 0 h10 m0 0 h120 m-150 0 h20 m130 0 h20 m-170 0 q10 0 10 10 m150 0 q0 -10 10 -10 m-160 10 v12 m150 0 v-12 m-150 12 q0 10 10 10 m130 0 q10 0 10 -10 m-140 10 h10 m60 0 h10 m0 0 h50 m-140 -10 v20 m150 0 v-20 m-150 20 v24 m150 0 v-24 m-150 24 q0 10 10 10 m130 0 q10 0 10 -10 m-140 10 h10 m110 0 h10 m20 -76 h10 m58 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 m-428 -32 h20 m428 0 h20 m-468 0 q10 0 10 10 m448 0 q0 -10 10 -10 m-458 10 v100 m448 0 v-100 m-448 100 q0 10 10 10 m428 0 q10 0 10 -10 m-438 10 h10 m108 0 h10 m0 0 h10 m58 0 h10 m0 0 h222 m22 -120 l2 0 m2 0 l2 0 m2 0 l2 0 m-588 230 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m92 0 h10 m20 0 h10 m26 0 h10 m20 0 h10 m78 0 h10 m-118 0 l20 0 m-1 0 q-9 0 -9 -10 l0 -24 q0 -10 10 -10 m98 44 l20 0 m-20 0 q10 0 10 -10 l0 -24 q0 -10 -10 -10 m-98 0 h10 m24 0 h10 m0 0 h54 m20 44 h10 m26 0 h10 m-250 0 h20 m230 0 h20 m-270 0 q10 0 10 10 m250 0 q0 -10 10 -10 m-260 10 v14 m250 0 v-14 m-250 14 q0 10 10 10 m230 0 q10 0 10 -10 m-240 10 h10 m0 0 h220 m20 -34 h10 m40 0 h10 m0 0 h10 m96 0 h10 m3 0 h-3"/>
   <polygon points="587 247 595 243 595 251"/>
   <polygon points="587 247 579 243 579 251"/>
</svg>