Google Git
Sign in
apache/iotdb-website/refs/heads/asf-site/./assets/SQL-Metadata-Operations_apache.html-4_I9eNYI.js
blob: ff46edea67334c0df05eda700ead663f161ca118 [file]
import{_ as r,c as t,b as a,d as l,a as e,w as o,r as c,o as i,e as p}from"./app-pmkzp6TS.js";const B={};function d(y,s){const n=c("RouteLink");return i(),t("div",null,[s[3]||(s[3]=a('<h1 id="metadata-operations" tabindex="-1"><a class="header-anchor" href="#metadata-operations"><span>Metadata Operations</span></a></h1><h2 id="_1-database-management" tabindex="-1"><a class="header-anchor" href="#_1-database-management"><span>1. Database Management</span></a></h2><h3 id="_1-1-create-database" tabindex="-1"><a class="header-anchor" href="#_1-1-create-database"><span>1.1 Create Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;">&lt;</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">WITH</span><span style="color:#ABB2BF;"> properties)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div>',5)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Database-Management_apache.html#_1-1-create-a-database"},{default:o(()=>[...s[0]||(s[0]=[p("Detailed syntax reference",-1)])]),_:1})]),s[4]||(s[4]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> database1</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#7F848E;font-style:italic;">-- Create database with 1-year TTL;</span></span>
<span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1 </span><span style="color:#C678DD;">with</span><span style="color:#ABB2BF;">(TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">);</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_1-2-use-database" tabindex="-1"><a class="header-anchor" href="#_1-2-use-database"><span>1.2 Use Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">USE</span><span style="color:#56B6C2;"> &lt;</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">USE</span><span style="color:#ABB2BF;"> database1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h3 id="_1-3-view-current-database" tabindex="-1"><a class="header-anchor" href="#_1-3-view-current-database"><span>1.3 View Current Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW CURRENT_DATABASE;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW CURRENT_DATABASE;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">CurrentDatabase</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">USE</span><span style="color:#ABB2BF;"> database1;</span></span>
<span class="line"><span style="color:#ABB2BF;">SHOW CURRENT_DATABASE;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">CurrentDatabase</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_1-4-list-all-databases" tabindex="-1"><a class="header-anchor" href="#_1-4-list-all-databases"><span>1.4 List All Databases</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW DATABASES (DETAILS)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div>`,18)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Database-Management_apache.html#_1-4-view-all-databases"},{default:o(()=>[...s[1]||(s[1]=[p("Detailed syntax reference",-1)])]),_:1})]),s[5]||(s[5]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show databases;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Database</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TTL(ms</span><span style="color:#ABB2BF;">)|</span><span style="color:#61AFEF;">SchemaReplicationFactor</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">DataReplicationFactor</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TimePartitionInterval</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">INF</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">604800000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">information_schema</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">INF</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show databases details;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+--------------------+------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Database</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TTL(ms</span><span style="color:#ABB2BF;">)|</span><span style="color:#61AFEF;">SchemaReplicationFactor</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">DataReplicationFactor</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TimePartitionInterval</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">SchemaRegionGroupNum</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">DataRegionGroupNum</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+--------------------+------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">database1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">INF</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">604800000</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">2</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">information_schema</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">INF</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------------+-------+-----------------------+---------------------+---------------------+--------------------+------------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_1-5-modify-database" tabindex="-1"><a class="header-anchor" href="#_1-5-modify-database"><span>1.5 Modify Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#C678DD;">database</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">identifier </span><span style="color:#C678DD;">SET</span><span style="color:#ABB2BF;"> PROPERTIES propertyAssignments</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> database1 </span><span style="color:#C678DD;">SET</span><span style="color:#ABB2BF;"> PROPERTIES TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h3 id="_1-6-drop-database" tabindex="-1"><a class="header-anchor" href="#_1-6-drop-database"><span>1.6 Drop Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;">&lt;</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#C678DD;"> IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h2 id="_2-table-management" tabindex="-1"><a class="header-anchor" href="#_2-table-management"><span>2. Table Management</span></a></h2><h3 id="_2-1-create-table" tabindex="-1"><a class="header-anchor" href="#_2-1-create-table"><span>2.1 Create Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">createTableStatement</span></span>
<span class="line"><span style="color:#ABB2BF;"> : </span><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? qualifiedName</span></span>
<span class="line"><span style="color:#98C379;"> &#39;(&#39;</span><span style="color:#ABB2BF;"> (columnDefinition (</span><span style="color:#98C379;">&#39;,&#39;</span><span style="color:#ABB2BF;"> columnDefinition)*)? </span><span style="color:#98C379;">&#39;)&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;"> charsetDesc?</span></span>
<span class="line"><span style="color:#ABB2BF;"> comment?</span></span>
<span class="line"><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">WITH</span><span style="color:#ABB2BF;"> properties)?</span></span>
<span class="line"><span style="color:#ABB2BF;"> ;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">charsetDesc</span></span>
<span class="line"><span style="color:#ABB2BF;"> : </span><span style="color:#C678DD;">DEFAULT</span><span style="color:#ABB2BF;">? (</span><span style="color:#C678DD;">CHAR</span><span style="color:#C678DD;"> SET</span><span style="color:#ABB2BF;"> | CHARSET | </span><span style="color:#C678DD;">CHARACTER</span><span style="color:#C678DD;"> SET</span><span style="color:#ABB2BF;">) EQ? identifierOrString</span></span>
<span class="line"><span style="color:#ABB2BF;"> ;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">columnDefinition</span></span>
<span class="line"><span style="color:#ABB2BF;"> : identifier columnCategory</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">(TAG | ATTRIBUTE | </span><span style="color:#C678DD;">TIME</span><span style="color:#ABB2BF;">) charsetName? comment?</span></span>
<span class="line"><span style="color:#ABB2BF;"> | identifier </span><span style="color:#C678DD;">type</span><span style="color:#ABB2BF;"> (columnCategory</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">(TAG | ATTRIBUTE | </span><span style="color:#C678DD;">TIME</span><span style="color:#ABB2BF;"> | FIELD))? charsetName? comment?</span></span>
<span class="line"><span style="color:#ABB2BF;"> ;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">charsetName</span></span>
<span class="line"><span style="color:#ABB2BF;"> : </span><span style="color:#C678DD;">CHAR</span><span style="color:#C678DD;"> SET</span><span style="color:#ABB2BF;"> identifier</span></span>
<span class="line"><span style="color:#ABB2BF;"> | CHARSET identifier</span></span>
<span class="line"><span style="color:#ABB2BF;"> | </span><span style="color:#C678DD;">CHARACTER</span><span style="color:#C678DD;"> SET</span><span style="color:#ABB2BF;"> identifier</span></span>
<span class="line"><span style="color:#ABB2BF;"> ;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">comment</span></span>
<span class="line"><span style="color:#ABB2BF;"> : COMMENT string</span></span>
<span class="line"><span style="color:#ABB2BF;"> ;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div>`,19)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.html#_1-1-create-a-table"},{default:o(()=>[...s[2]||(s[2]=[p("Detailed syntax reference",-1)])]),_:1})]),s[6]||(s[6]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#61AFEF;"> table1</span><span style="color:#ABB2BF;"> (</span></span>
<span class="line"><span style="color:#C678DD;"> time</span><span style="color:#C678DD;"> TIMESTAMP</span><span style="color:#C678DD;"> TIME</span><span style="color:#ABB2BF;">,</span></span>
<span class="line"><span style="color:#ABB2BF;"> region STRING TAG,</span></span>
<span class="line"><span style="color:#ABB2BF;"> plant_id STRING TAG,</span></span>
<span class="line"><span style="color:#ABB2BF;"> device_id STRING TAG,</span></span>
<span class="line"><span style="color:#ABB2BF;"> model_id STRING ATTRIBUTE,</span></span>
<span class="line"><span style="color:#ABB2BF;"> maintenance STRING ATTRIBUTE COMMENT </span><span style="color:#98C379;">&#39;maintenance&#39;</span><span style="color:#ABB2BF;">,</span></span>
<span class="line"><span style="color:#ABB2BF;"> temperature </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;"> FIELD COMMENT </span><span style="color:#98C379;">&#39;temperature&#39;</span><span style="color:#ABB2BF;">,</span></span>
<span class="line"><span style="color:#ABB2BF;"> humidity </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;"> FIELD COMMENT </span><span style="color:#98C379;">&#39;humidity&#39;</span><span style="color:#ABB2BF;">,</span></span>
<span class="line"><span style="color:#C678DD;"> status</span><span style="color:#C678DD;"> BOOLEAN</span><span style="color:#ABB2BF;"> FIELD COMMENT </span><span style="color:#98C379;">&#39;status&#39;</span><span style="color:#ABB2BF;">,</span></span>
<span class="line"><span style="color:#ABB2BF;"> arrival_time </span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#ABB2BF;"> FIELD COMMENT </span><span style="color:#98C379;">&#39;arrival_time&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;">) COMMENT </span><span style="color:#98C379;">&#39;table1&#39;</span><span style="color:#C678DD;"> WITH</span><span style="color:#ABB2BF;"> (TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">);</span></span>
<span class="line"></span>
<span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#61AFEF;"> if</span><span style="color:#C678DD;"> not</span><span style="color:#C678DD;"> exists</span><span style="color:#ABB2BF;"> tableB ();</span></span>
<span class="line"></span>
<span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#61AFEF;"> tableC</span><span style="color:#ABB2BF;"> (</span></span>
<span class="line"><span style="color:#98C379;"> &quot;Site&quot;</span><span style="color:#ABB2BF;"> STRING TAG,</span></span>
<span class="line"><span style="color:#98C379;"> &quot;Temperature&quot;</span><span style="color:#ABB2BF;"> int32 FIELD COMMENT </span><span style="color:#98C379;">&#39;temperature&#39;</span></span>
<span class="line"><span style="color:#ABB2BF;"> ) </span><span style="color:#C678DD;">with</span><span style="color:#ABB2BF;"> (TTL</span><span style="color:#56B6C2;">=</span><span style="color:#C678DD;">DEFAULT</span><span style="color:#ABB2BF;">);</span></span>
<span class="line"><span style="color:#ABB2BF;"> </span></span>
<span class="line"><span style="color:#7F848E;font-style:italic;"> -- Custom time column: named time_test, located in the second column of the table. (Support from V2.0.8)</span></span>
<span class="line"><span style="color:#C678DD;"> CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#61AFEF;"> table1</span><span style="color:#ABB2BF;"> (</span></span>
<span class="line"><span style="color:#ABB2BF;"> region STRING TAG, </span></span>
<span class="line"><span style="color:#ABB2BF;"> time_user_defined </span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#C678DD;"> TIME</span><span style="color:#ABB2BF;">, </span></span>
<span class="line"><span style="color:#ABB2BF;"> temperature </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;"> FIELD</span></span>
<span class="line"><span style="color:#ABB2BF;"> );</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p>Note: If your terminal does not support multi-line paste (e.g., Windows CMD), please reformat the SQL statement into a single line before execution.</p><h3 id="_2-2-list-tables" tabindex="-1"><a class="header-anchor" href="#_2-2-list-tables"><span>2.2 List Tables</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW TABLES (DETAILS)? ((</span><span style="color:#C678DD;">FROM</span><span style="color:#ABB2BF;"> | </span><span style="color:#C678DD;">IN</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">database_name</span><span style="color:#ABB2BF;">)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show tables </span><span style="color:#C678DD;">from</span><span style="color:#ABB2BF;"> database1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+---------+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TableName</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TTL(ms</span><span style="color:#ABB2BF;">)|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">31536000000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------+---------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show tables details </span><span style="color:#C678DD;">from</span><span style="color:#ABB2BF;"> database1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+---------------+-----------+------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TableName</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TTL(ms</span><span style="color:#ABB2BF;">)|</span><span style="color:#61AFEF;">Status</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">Comment</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+-----------+------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">31536000000</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+---------------+-----------+------+-------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_2-3-describe-table-columns" tabindex="-1"><a class="header-anchor" href="#_2-3-describe-table-columns"><span>2.3 Describe Table Columns</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">(</span><span style="color:#C678DD;">DESC</span><span style="color:#ABB2BF;"> | DESCRIBE) </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">TABLE_NAME</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> (DETAILS)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">desc</span><span style="color:#ABB2BF;"> table1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+------------+---------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">ColumnName</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">DataType</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Category</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------+---------+---------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| time|</span><span style="color:#61AFEF;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TIME</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">region</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">plant_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">device_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">model_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">ATTRIBUTE</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">maintenance</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">ATTRIBUTE</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">temperature</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FLOAT</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">humidity</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FLOAT</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">status</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">BOOLEAN</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">arrival_time</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------+---------+---------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">desc</span><span style="color:#ABB2BF;"> table1 details;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+------------+---------+---------+------+------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">ColumnName</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">DataType</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Category</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">Status</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Comment</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------+---------+---------+------+------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| time|</span><span style="color:#61AFEF;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TIME</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">region</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">plant_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">device_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">TAG</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">model_id</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">ATTRIBUTE</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">maintenance</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">STRING</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">ATTRIBUTE</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">maintenance</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">temperature</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FLOAT</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">temperature</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">humidity</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FLOAT</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">humidity</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">status</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">BOOLEAN</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">status</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">arrival_time</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">FIELD</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">USING</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">arrival_time</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------------+---------+---------+------+------------+</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_2-4-view-table-creation-statement" tabindex="-1"><a class="header-anchor" href="#_2-4-view-table-creation-statement"><span>2.4 View Table Creation Statement</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW </span><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#56B6C2;"> &lt;</span><span style="color:#ABB2BF;">TABLE_NAME</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">show </span><span style="color:#C678DD;">create</span><span style="color:#C678DD;"> table</span><span style="color:#ABB2BF;"> table1;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><div class="language-shell line-numbers-mode" data-highlighter="shiki" data-ext="shell" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-shell"><span class="line"><span style="color:#61AFEF;">+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Table</span><span style="color:#ABB2BF;">| </span><span style="color:#61AFEF;">Create</span><span style="color:#98C379;"> Table</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#61AFEF;">+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">table1</span><span style="color:#ABB2BF;">|</span><span style="color:#61AFEF;">CREATE</span><span style="color:#98C379;"> TABLE</span><span style="color:#98C379;"> &quot;table1&quot;</span><span style="color:#ABB2BF;"> (</span><span style="color:#98C379;">&quot;region&quot;</span><span style="color:#98C379;"> STRING</span><span style="color:#98C379;"> TAG,&quot;plant_id&quot;</span><span style="color:#98C379;"> STRING</span><span style="color:#98C379;"> TAG,&quot;device_id&quot;</span><span style="color:#98C379;"> STRING</span><span style="color:#98C379;"> TAG,&quot;model_id&quot;</span><span style="color:#98C379;"> STRING</span><span style="color:#98C379;"> ATTRIBUTE,&quot;maintenance&quot;</span><span style="color:#98C379;"> STRING</span><span style="color:#98C379;"> ATTRIBUTE,&quot;temperature&quot;</span><span style="color:#98C379;"> FLOAT</span><span style="color:#98C379;"> FIELD,&quot;humidity&quot;</span><span style="color:#98C379;"> FLOAT</span><span style="color:#98C379;"> FIELD,&quot;status&quot;</span><span style="color:#98C379;"> BOOLEAN</span><span style="color:#98C379;"> FIELD,&quot;arrival_time&quot;</span><span style="color:#98C379;"> TIMESTAMP</span><span style="color:#98C379;"> FIELD</span><span style="color:#ABB2BF;">) WITH (</span><span style="color:#E06C75;">ttl</span><span style="color:#56B6C2;">=</span><span style="color:#98C379;">31536000000</span><span style="color:#ABB2BF;">)|</span></span>
<span class="line"><span style="color:#61AFEF;">+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+</span></span>
<span class="line"><span style="color:#61AFEF;">Total</span><span style="color:#98C379;"> line</span><span style="color:#98C379;"> number</span><span style="color:#98C379;"> =</span><span style="color:#D19A66;"> 1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_2-5-modify-table" tabindex="-1"><a class="header-anchor" href="#_2-5-modify-table"><span>2.5 Modify Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">#addColumn;</span></span>
<span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? tableName</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">qualifiedName </span><span style="color:#C678DD;">ADD</span><span style="color:#ABB2BF;"> COLUMN (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? column</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">columnDefinition COMMENT </span><span style="color:#98C379;">&#39;column_comment&#39;</span><span style="color:#ABB2BF;">; </span></span>
<span class="line"><span style="color:#ABB2BF;">#dropColumn; </span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? tableName</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">qualifiedName </span><span style="color:#C678DD;">DROP</span><span style="color:#ABB2BF;"> COLUMN (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? column</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">identifier;</span></span>
<span class="line"><span style="color:#ABB2BF;">#setTableProperties; </span></span>
<span class="line"><span style="color:#ABB2BF;">// </span><span style="color:#C678DD;">set</span><span style="color:#ABB2BF;"> TTL can </span><span style="color:#C678DD;">use</span><span style="color:#ABB2BF;"> this;</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? tableName</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">qualifiedName </span><span style="color:#C678DD;">SET</span><span style="color:#ABB2BF;"> PROPERTIES propertyAssignments; </span></span>
<span class="line"><span style="color:#ABB2BF;">| COMMENT </span><span style="color:#C678DD;">ON</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> tableName</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">qualifiedName </span><span style="color:#C678DD;">IS</span><span style="color:#98C379;"> &#39;table_comment&#39;</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#ABB2BF;">| COMMENT </span><span style="color:#C678DD;">ON</span><span style="color:#ABB2BF;"> COLUMN </span><span style="color:#D19A66;">tableName</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">column</span><span style="color:#C678DD;"> IS</span><span style="color:#98C379;"> &#39;column_comment&#39;</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> table1 </span><span style="color:#C678DD;">ADD</span><span style="color:#ABB2BF;"> COLUMN </span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> a TAG COMMENT </span><span style="color:#98C379;">&#39;a&#39;</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> table1 </span><span style="color:#C678DD;">ADD</span><span style="color:#ABB2BF;"> COLUMN </span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> b </span><span style="color:#C678DD;">FLOAT</span><span style="color:#ABB2BF;"> FIELD COMMENT </span><span style="color:#98C379;">&#39;b&#39;</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> table1 </span><span style="color:#C678DD;">set</span><span style="color:#ABB2BF;"> properties TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">3600</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#C678DD;">COMMENT ON TABLE </span><span style="color:#ABB2BF;">table1 </span><span style="color:#C678DD;">IS</span><span style="color:#98C379;"> &#39;table1&#39;</span><span style="color:#ABB2BF;">;</span></span>
<span class="line"><span style="color:#C678DD;">COMMENT ON COLUMN </span><span style="color:#D19A66;">table1</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">a</span><span style="color:#C678DD;"> IS</span><span style="color:#C678DD;"> null</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_2-6-drop-table" tabindex="-1"><a class="header-anchor" href="#_2-6-drop-table"><span>2.6 Drop Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;">&lt;</span><span style="color:#ABB2BF;">TABLE_NAME</span><span style="color:#56B6C2;">&gt;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> table1;</span></span>
<span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#D19A66;"> database1</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">table1</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div></div></div>`,35))])}const A=r(B,[["render",d]]),u=JSON.parse('{"path":"/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.html","title":"Metadata Operations","lang":"en-US","frontmatter":{"description":"Metadata Operations 1. Database Management 1.1 Create Database Syntax: Examples: 1.2 Use Database Syntax: Examples: 1.3 View Current Database Syntax: Examples: 1.4 List All Data...","head":[["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Metadata Operations\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2026-04-15T10:39:00.000Z\\",\\"author\\":[]}"],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Metadata Operations"}],["meta",{"property":"og:description","content":"Metadata Operations 1. Database Management 1.1 Create Database Syntax: Examples: 1.2 Use Database Syntax: Examples: 1.3 View Current Database Syntax: Examples: 1.4 List All Data..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2026-04-15T10:39:00.000Z"}],["meta",{"property":"article:modified_time","content":"2026-04-15T10:39:00.000Z"}],["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.html"}]]},"git":{"createdTime":1754033766000,"updatedTime":1776249540000,"contributors":[{"name":"leto-b","username":"leto-b","email":"bingqian.bai@timecho.com","commits":7,"url":"https://github.com/leto-b"},{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":1,"url":"https://github.com/CritasWang"}]},"readingTime":{"minutes":2.79,"words":836},"filePathRelative":"UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md","autoDesc":true}');export{A as comp,u as data};