Google Git
Sign in
apache/iotdb-website/refs/heads/asf-site/./assets/SQL-Metadata-Operations_apache.html-C12db96i.js
blob: 4f1d653f72df9c18dca6ee9f682f17b551bd2345 [file]
import{_ as r,c,b as n,d as e,e as a,a as o,w as p,r as t,o as i}from"./app-pmkzp6TS.js";const B={};function d(y,s){const l=t("RouteLink");return i(),c("div",null,[s[6]||(s[6]=n('<h1 id="元数据操作" tabindex="-1"><a class="header-anchor" href="#元数据操作"><span>元数据操作</span></a></h1><h2 id="_1-数据库管理" tabindex="-1"><a class="header-anchor" href="#_1-数据库管理"><span>1. 数据库管理</span></a></h2><h3 id="_1-1-创建数据库" tabindex="-1"><a class="header-anchor" href="#_1-1-创建数据库"><span>1.1 创建数据库</span></a></h3><p><strong>语法：</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)),e("p",null,[s[1]||(s[1]=a("更多详细语法说明请参考：",-1)),o(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Database-Management_apache.html#_1-1-%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E5%BA%93"},{default:p(()=>[...s[0]||(s[0]=[a("创建数据库",-1)])]),_:1})]),s[7]||(s[7]=n(`<p><strong>示例：</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;">-- 创建一个名为 database1 的数据库，并将数据库的TTL时间设置为1年;</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-使用数据库" tabindex="-1"><a class="header-anchor" href="#_1-2-使用数据库"><span>1.2 使用数据库</span></a></h3><p><strong>语法：</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>示例:</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-查看当前数据库" tabindex="-1"><a class="header-anchor" href="#_1-3-查看当前数据库"><span>1.3 查看当前数据库</span></a></h3><p><strong>语法：</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>示例：</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-查看所有数据库" tabindex="-1"><a class="header-anchor" href="#_1-4-查看所有数据库"><span>1.4 查看所有数据库</span></a></h3><p><strong>语法：</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)),e("p",null,[s[3]||(s[3]=a("更多返回结果详细说明请参考：",-1)),o(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Database-Management_apache.html#_1-4-%E6%9F%A5%E7%9C%8B%E6%89%80%E6%9C%89%E6%95%B0%E6%8D%AE%E5%BA%93"},{default:p(()=>[...s[2]||(s[2]=[a("查看所有数据库",-1)])]),_:1})]),s[8]||(s[8]=n(`<p><strong>示例:</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-修改数据库" tabindex="-1"><a class="header-anchor" href="#_1-5-修改数据库"><span>1.5 修改数据库</span></a></h3><p><strong>语法：</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>示例:</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-删除数据库" tabindex="-1"><a class="header-anchor" href="#_1-6-删除数据库"><span>1.6 删除数据库</span></a></h3><p><strong>语法：</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 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>示例:</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-表管理" tabindex="-1"><a class="header-anchor" href="#_2-表管理"><span>2. 表管理</span></a></h2><h3 id="_2-1-创建表" tabindex="-1"><a class="header-anchor" href="#_2-1-创建表"><span>2.1 创建表</span></a></h3><p><strong>语法：</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)),e("p",null,[s[5]||(s[5]=a("更多详细语法说明请参考：",-1)),o(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Table-Management_apache.html#_1-1-%E5%88%9B%E5%BB%BA%E8%A1%A8"},{default:p(()=>[...s[4]||(s[4]=[a("创建表",-1)])]),_:1})]),s[9]||(s[9]=n(`<p><strong>示例:</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:#ABB2BF;"> station STRING TAG,</span></span>
<span class="line"><span style="color:#ABB2BF;"> temperature 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;">-- 自定义时间列:命名为time_test, 位于表的第二列 (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>注意：若您使用的终端不支持多行粘贴（例如 Windows CMD），请将 SQL 语句调整为单行格式后再执行。</p><h3 id="_2-2-查看表" tabindex="-1"><a class="header-anchor" href="#_2-2-查看表"><span>2.2 查看表</span></a></h3><p><strong>语法：</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>示例:</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-查看表的列" tabindex="-1"><a class="header-anchor" href="#_2-3-查看表的列"><span>2.3 查看表的列</span></a></h3><p><strong>语法：</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>示例:</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-查看表的创建信息" tabindex="-1"><a class="header-anchor" href="#_2-4-查看表的创建信息"><span>2.4 查看表的创建信息</span></a></h3><p><strong>语法：</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>示例:</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-修改表" tabindex="-1"><a class="header-anchor" href="#_2-5-修改表"><span>2.5 修改表</span></a></h3><p><strong>语法：</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:#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>示例:</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-删除表" tabindex="-1"><a class="header-anchor" href="#_2-6-删除表"><span>2.6 删除表</span></a></h3><p><strong>语法：</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 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>示例:</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":"/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.html","title":"元数据操作","lang":"zh-CN","frontmatter":{"description":"元数据操作 1. 数据库管理 1.1 创建数据库 语法： 更多详细语法说明请参考： 示例： 1.2 使用数据库 语法： 示例: 1.3 查看当前数据库 语法： 示例： 1.4 查看所有数据库 语法： 更多返回结果详细说明请参考： 示例: 1.5 修改数据库 语法： 示例: 1.6 删除数据库 语法： 示例: 2. 表管理 2.1 创建表 语法： 更多详...","head":[["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"元数据操作\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2026-04-15T10:39:00.000Z\\",\\"author\\":[]}"],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"元数据操作"}],["meta",{"property":"og:description","content":"元数据操作 1. 数据库管理 1.1 创建数据库 语法： 更多详细语法说明请参考： 示例： 1.2 使用数据库 语法： 示例: 1.3 查看当前数据库 语法： 示例： 1.4 查看所有数据库 语法： 更多返回结果详细说明请参考： 示例: 1.5 修改数据库 语法： 示例: 1.6 删除数据库 语法： 示例: 2. 表管理 2.1 创建表 语法： 更多详..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"zh-CN"}],["meta",{"property":"og:locale:alternate","content":"en-US"}],["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":"en-us","href":"https://iotdb.apache.org/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":3.27,"words":980},"filePathRelative":"zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations_apache.md","autoDesc":true}');export{A as comp,u as data};