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

<svg xmlns="http://www.w3.org/2000/svg" width="589" height="359">
   <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="147" y="35" width="108" height="32" rx="10"/>
   <rect x="145"
         y="33"
         width="108"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="155" y="53">OR REPLACE</text>
   <rect x="295" y="3" width="166" height="32" rx="10"/>
   <rect x="293"
         y="1"
         width="166"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="303" y="21">MATERIALIZED VIEW</text>
   <rect x="45" y="177" width="120" height="32" rx="10"/>
   <rect x="43"
         y="175"
         width="120"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="53" y="195">IF NOT EXISTS</text>
   <rect x="205" y="145" width="92" height="32"/>
   <rect x="203" y="143" width="92" height="32" class="nonterminal"/>
   <text class="nonterminal" x="213" y="163">view_name</text>
   <rect x="337" y="145" width="26" height="32" rx="10"/>
   <rect x="335"
         y="143"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="345" y="163">(</text>
   <rect x="403" y="145" width="78" height="32"/>
   <rect x="401" y="143" width="78" height="32" class="nonterminal"/>
   <text class="nonterminal" x="411" y="163">col_ident</text>
   <rect x="403" y="101" width="24" height="32" rx="10"/>
   <rect x="401"
         y="99"
         width="24"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="411" y="119">,</text>
   <rect x="521" y="145" width="26" height="32" rx="10"/>
   <rect x="519"
         y="143"
         width="26"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="529" y="163">)</text>
   <rect x="60" y="259" width="104" height="32" rx="10"/>
   <rect x="58"
         y="257"
         width="104"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="68" y="277">IN CLUSTER</text>
   <rect x="184" y="259" width="108" height="32"/>
   <rect x="182" y="257" width="108" height="32" class="nonterminal"/>
   <text class="nonterminal" x="192" y="277">cluster_name</text>
   <rect x="352" y="259" width="58" height="32" rx="10"/>
   <rect x="350"
         y="257"
         width="58"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="360" y="277">WITH</text>
   <rect x="430" y="259" width="102" height="32"/>
   <rect x="428" y="257" width="102" height="32" class="nonterminal"/>
   <text class="nonterminal" x="438" y="277">with_options</text>
   <rect x="405" y="325" width="40" height="32" rx="10"/>
   <rect x="403"
         y="323"
         width="40"
         height="32"
         class="terminal"
         rx="10"/>
   <text class="terminal" x="413" y="343">AS</text>
   <rect x="465" y="325" width="96" height="32"/>
   <rect x="463" y="323" width="96" height="32" class="nonterminal"/>
   <text class="nonterminal" x="473" y="343">select_stmt</text>
   <path class="line"
         d="m17 17 h2 m0 0 h10 m76 0 h10 m20 0 h10 m0 0 h118 m-148 0 h20 m128 0 h20 m-168 0 q10 0 10 10 m148 0 q0 -10 10 -10 m-158 10 v12 m148 0 v-12 m-148 12 q0 10 10 10 m128 0 q10 0 10 -10 m-138 10 h10 m108 0 h10 m20 -32 h10 m166 0 h10 m2 0 l2 0 m2 0 l2 0 m2 0 l2 0 m-480 142 l2 0 m2 0 l2 0 m2 0 l2 0 m22 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 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 m22 -34 l2 0 m2 0 l2 0 m2 0 l2 0 m-571 82 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 m40 -32 h10 m0 0 h190 m-220 0 h20 m200 0 h20 m-240 0 q10 0 10 10 m220 0 q0 -10 10 -10 m-230 10 v12 m220 0 v-12 m-220 12 q0 10 10 10 m200 0 q10 0 10 -10 m-210 10 h10 m58 0 h10 m0 0 h10 m102 0 h10 m22 -32 l2 0 m2 0 l2 0 m2 0 l2 0 m-191 98 l2 0 m2 0 l2 0 m2 0 l2 0 m2 0 h10 m40 0 h10 m0 0 h10 m96 0 h10 m3 0 h-3"/>
   <polygon points="579 339 587 335 587 343"/>
   <polygon points="579 339 571 335 571 343"/>
</svg>