Google Git
Sign in
apache/iotdb-website/refs/heads/asf-staging/./assets/SQL-Metadata-Operations.html-Bz7BEvNH.js
blob: 6ddec620d4bbea22a40364e86ff3a98e94ccdcd0 [file]
import{_ as r,c as t,b as a,d as e,e as n,a as p,w as o,r as c,o as i}from"./app-C1IcKGP3.js";const B={};function d(y,s){const l=c("RouteLink");return i(),t("div",null,[s[6]||(s[6]=a('<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]=n("更多详细语法说明请参考：",-1)),p(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Database-Management.html#_1-1-%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AE%E5%BA%93"},{default:o(()=>[...s[0]||(s[0]=[n("创建数据库",-1)])]),_:1})]),s[7]||(s[7]=a(`<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;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> SHOW CURRENT_DATABASE;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|CurrentDatabase|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> USE</span><span style="color:#ABB2BF;"> test;</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> SHOW CURRENT_DATABASE;</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|CurrentDatabase|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| iot_database|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------------+</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></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>`,15)),e("p",null,[s[3]||(s[3]=n("更多返回结果详细说明请参考：",-1)),p(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Database-Management.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:o(()=>[...s[2]||(s[2]=[n("查看所有数据库",-1)])]),_:1})]),s[8]||(s[8]=a(`<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;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show databases</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">Database</span><span style="color:#ABB2BF;">|TTL(ms)|SchemaReplicationFactor|DataReplicationFactor|TimePartitionInterval|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|test_prop| </span><span style="color:#D19A66;">300</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">100000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| test2| </span><span style="color:#D19A66;">300</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">604800000</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show databases details</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+-----------------------+-----------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">Database</span><span style="color:#ABB2BF;">|TTL(ms)|SchemaReplicationFactor|DataReplicationFactor|TimePartitionInterval|SchemaRegionGroupNum| DataRegionGroupNum|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+-----------------------+-----------------------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|test_prop| </span><span style="color:#D19A66;">300</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">100000</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| test2| </span><span style="color:#D19A66;">300</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">3</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">604800000</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">1</span><span style="color:#ABB2BF;">| </span><span style="color:#D19A66;">2</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-----------------------+---------------------+---------------------+-----------------------+-----------------------+</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="_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></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>`,16)),e("p",null,[s[5]||(s[5]=n("更多详细语法说明请参考：",-1)),p(l,{to:"/zh/UserGuide/latest-Table/Basic-Concept/Table-Management.html#_1-1-%E5%88%9B%E5%BB%BA%E8%A1%A8"},{default:o(()=>[...s[4]||(s[4]=[n("创建表",-1)])]),_:1})]),s[9]||(s[9]=a(`<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;"> table2 ();</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;场站&quot;</span><span style="color:#ABB2BF;"> STRING TAG,</span></span>
<span class="line"><span style="color:#98C379;"> &quot;温度&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></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></div><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;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show tables </span><span style="color:#C678DD;">from</span><span style="color:#ABB2BF;"> test_db</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|TableName|TTL(ms)|Comment|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| test| INF| TEST|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+-------+</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#ABB2BF;"> show tables details </span><span style="color:#C678DD;">from</span><span style="color:#ABB2BF;"> test_db</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|TableName|TTL(ms)| </span><span style="color:#C678DD;">Status</span><span style="color:#ABB2BF;">|Comment|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| test| INF| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| TEST|</span></span>
<span class="line"><span style="color:#ABB2BF;">| turbine| INF|PRE_CREATE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| car| </span><span style="color:#D19A66;">1000</span><span style="color:#ABB2BF;">|PRE_DELETE| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">---------+-------+----------+-------+</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></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:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> desc</span><span style="color:#ABB2BF;"> tableB</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|ColumnName| DataType| Category|Comment|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">time</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">TIME</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| a| STRING| TAG| a|</span></span>
<span class="line"><span style="color:#ABB2BF;">| b| STRING| ATTRIBUTE| b|</span></span>
<span class="line"><span style="color:#ABB2BF;">| c| INT32| FIELD| c|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+-------+</span></span>
<span class="line"></span>
<span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">&gt;</span><span style="color:#C678DD;"> desc</span><span style="color:#ABB2BF;"> tableB details</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">|ColumnName| DataType| Category| </span><span style="color:#C678DD;">Status</span><span style="color:#ABB2BF;">|Comment|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+----------+-------+</span></span>
<span class="line"><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">time</span><span style="color:#ABB2BF;">|</span><span style="color:#C678DD;">TIMESTAMP</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">TIME</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| </span><span style="color:#C678DD;">null</span><span style="color:#ABB2BF;">|</span></span>
<span class="line"><span style="color:#ABB2BF;">| a| STRING| TAG| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| a|</span></span>
<span class="line"><span style="color:#ABB2BF;">| b| STRING| ATTRIBUTE| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| b|</span></span>
<span class="line"><span style="color:#ABB2BF;">| c| INT32| FIELD| </span><span style="color:#C678DD;">USING</span><span style="color:#ABB2BF;">| c|</span></span>
<span class="line"><span style="color:#ABB2BF;">| d| INT32| FIELD|PRE_DELETE| d|</span></span>
<span class="line"><span style="color:#ABB2BF;">+</span><span style="color:#7F848E;font-style:italic;">----------+---------+-----------+----------+-------+</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></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:#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;"> #addColumn</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 #dropColumn</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 #setTableProperties</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>
<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></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><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;"> tableB </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>
<span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> tableB </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>
<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>
<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></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></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:#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>示例:</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;"> tableA</span></span>
<span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#D19A66;"> test</span><span style="color:#ABB2BF;">.</span><span style="color:#D19A66;">tableB</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>`,22))])}const D=r(B,[["render",d]]),u=JSON.parse('{"path":"/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.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-01-12T10:25:39.000Z\\",\\"author\\":[]}"],["meta",{"property":"og:url","content":"https://iotdb.apache.org/zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.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-01-12T10:25:39.000Z"}],["meta",{"property":"article:modified_time","content":"2026-01-12T10:25:39.000Z"}],["link",{"rel":"alternate","hreflang":"en-us","href":"https://iotdb.apache.org/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.html"}]]},"git":{"createdTime":1768213539000,"updatedTime":1768213539000,"contributors":[{"name":"CritasWang","username":"CritasWang","email":"critas@outlook.com","commits":1,"url":"https://github.com/CritasWang"}]},"readingTime":{"minutes":2.68,"words":804},"filePathRelative":"zh/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.md","autoDesc":true}');export{D as comp,u as data};