| import{_ as t,c as r,b as a,d as l,a as e,w as p,r as c,o as i,e as o}from"./app-C1IcKGP3.js";const B={};function d(y,s){const n=c("RouteLink");return i(),r("div",null,[s[3]||(s[3]=a('<h1 id="metadata-operations" tabindex="-1"><a class="header-anchor" href="#metadata-operations"><span>Metadata Operations</span></a></h1><h2 id="_1-database-management" tabindex="-1"><a class="header-anchor" href="#_1-database-management"><span>1. Database Management</span></a></h2><h3 id="_1-1-create-database" tabindex="-1"><a class="header-anchor" href="#_1-1-create-database"><span>1.1 Create Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;"><</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">WITH</span><span style="color:#ABB2BF;"> properties)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div>',5)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Database-Management.html#_1-1-create-a-database"},{default:p(()=>[...s[0]||(s[0]=[o("Detailed syntax reference",-1)])]),_:1})]),s[4]||(s[4]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> database1</span><span style="color:#ABB2BF;">;</span></span> |
| <span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1;</span></span> |
| <span class="line"></span> |
| <span class="line"><span style="color:#7F848E;font-style:italic;">-- Create database with 1-year TTL</span></span> |
| <span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#61AFEF;"> IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1 </span><span style="color:#C678DD;">with</span><span style="color:#ABB2BF;">(TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">);</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div><div class="line-number"></div></div></div><h3 id="_1-2-use-database" tabindex="-1"><a class="header-anchor" href="#_1-2-use-database"><span>1.2 Use Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">USE</span><span style="color:#56B6C2;"> <</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">></span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">USE</span><span style="color:#ABB2BF;"> database1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h3 id="_1-3-view-current-database" tabindex="-1"><a class="header-anchor" href="#_1-3-view-current-database"><span>1.3 View Current Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW CURRENT_DATABASE</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">></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;">></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;">></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-list-all-databases" tabindex="-1"><a class="header-anchor" href="#_1-4-list-all-databases"><span>1.4 List All Databases</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW DATABASES (DETAILS)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div>`,15)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Database-Management.html#_1-4-view-all-databases"},{default:p(()=>[...s[1]||(s[1]=[o("Detailed syntax reference",-1)])]),_:1})]),s[5]||(s[5]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">></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;">></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-modify-database" tabindex="-1"><a class="header-anchor" href="#_1-5-modify-database"><span>1.5 Modify Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#C678DD;">database</span><span style="color:#56B6C2;">=</span><span style="color:#ABB2BF;">identifier </span><span style="color:#C678DD;">SET</span><span style="color:#ABB2BF;"> PROPERTIES propertyAssignments</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> database1 </span><span style="color:#C678DD;">SET</span><span style="color:#ABB2BF;"> PROPERTIES TTL</span><span style="color:#56B6C2;">=</span><span style="color:#D19A66;">31536000000</span><span style="color:#ABB2BF;">;</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h3 id="_1-6-drop-database" tabindex="-1"><a class="header-anchor" href="#_1-6-drop-database"><span>1.6 Drop Database</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;"><</span><span style="color:#C678DD;">DATABASE_NAME</span><span style="color:#56B6C2;">></span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> DATABASE</span><span style="color:#C678DD;"> IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;"> database1</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><h2 id="_2-table-management" tabindex="-1"><a class="header-anchor" href="#_2-table-management"><span>2. Table Management</span></a></h2><h3 id="_2-1-create-table" tabindex="-1"><a class="header-anchor" href="#_2-1-create-table"><span>2.1 Create Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">createTableStatement</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> : </span><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> NOT</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? qualifiedName</span></span> |
| <span class="line"><span style="color:#98C379;"> '('</span><span style="color:#ABB2BF;"> (columnDefinition (</span><span style="color:#98C379;">','</span><span style="color:#ABB2BF;"> columnDefinition)*)? </span><span style="color:#98C379;">')'</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)),l("p",null,[e(n,{to:"/UserGuide/latest-Table/Basic-Concept/Table-Management.html#_1-1-create-a-table"},{default:p(()=>[...s[2]||(s[2]=[o("Detailed syntax reference",-1)])]),_:1})]),s[6]||(s[6]=a(`<p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">CREATE</span><span style="color:#C678DD;"> TABLE</span><span style="color:#61AFEF;"> table1</span><span style="color:#ABB2BF;"> (</span></span> |
| <span class="line"><span style="color:#C678DD;"> time</span><span style="color:#C678DD;"> TIMESTAMP</span><span style="color:#C678DD;"> TIME</span><span style="color:#ABB2BF;">,</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> region STRING TAG,</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> plant_id STRING TAG,</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> device_id STRING TAG,</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> model_id STRING ATTRIBUTE,</span></span> |
| <span class="line"><span style="color:#ABB2BF;"> maintenance STRING ATTRIBUTE COMMENT </span><span style="color:#98C379;">'maintenance'</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;">'temperature'</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;">'humidity'</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;">'status'</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;">'arrival_time'</span></span> |
| <span class="line"><span style="color:#ABB2BF;">) COMMENT </span><span style="color:#98C379;">'table1'</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;"> "plant"</span><span style="color:#ABB2BF;"> STRING TAG,</span></span> |
| <span class="line"><span style="color:#98C379;"> "temperature"</span><span style="color:#ABB2BF;"> INT32 FIELD COMMENT </span><span style="color:#98C379;">'temperature'</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-list-tables" tabindex="-1"><a class="header-anchor" href="#_2-2-list-tables"><span>2.2 List Tables</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">SHOW TABLES (DETAILS)? ((</span><span style="color:#C678DD;">FROM</span><span style="color:#ABB2BF;"> | </span><span style="color:#C678DD;">IN</span><span style="color:#ABB2BF;">) </span><span style="color:#C678DD;">database_name</span><span style="color:#ABB2BF;">)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">></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;">></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-describe-table-columns" tabindex="-1"><a class="header-anchor" href="#_2-3-describe-table-columns"><span>2.3 Describe Table Columns</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">(</span><span style="color:#C678DD;">DESC</span><span style="color:#ABB2BF;"> | DESCRIBE) </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">TABLE_NAME</span><span style="color:#56B6C2;">></span><span style="color:#ABB2BF;"> (DETAILS)?</span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#ABB2BF;">IoTDB</span><span style="color:#56B6C2;">></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;">></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-modify-table" tabindex="-1"><a class="header-anchor" href="#_2-4-modify-table"><span>2.4 Modify Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#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;">'column_comment'</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;"> 'table_comment'</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;"> 'column_comment'</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>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">ALTER</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> 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;">'a'</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;"> 'table1'</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-drop-table" tabindex="-1"><a class="header-anchor" href="#_2-5-drop-table"><span>2.5 Drop Table</span></a></h3><p><strong>Syntax:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> (</span><span style="color:#C678DD;">IF</span><span style="color:#C678DD;"> EXISTS</span><span style="color:#ABB2BF;">)? </span><span style="color:#56B6C2;"><</span><span style="color:#ABB2BF;">TABLE_NAME</span><span style="color:#56B6C2;">></span></span></code></pre><div class="line-numbers" aria-hidden="true" style="counter-reset:line-number 0;"><div class="line-number"></div></div></div><p><strong>Examples:</strong></p><div class="language-sql line-numbers-mode" data-highlighter="shiki" data-ext="sql" style="background-color:#282c34;color:#abb2bf;"><pre class="shiki one-dark-pro vp-code"><code class="language-sql"><span class="line"><span style="color:#C678DD;">DROP</span><span style="color:#C678DD;"> TABLE</span><span style="color:#ABB2BF;"> 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 b=t(B,[["render",d]]),A=JSON.parse('{"path":"/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.html","title":"Metadata Operations","lang":"en-US","frontmatter":{"description":"Metadata Operations 1. Database Management 1.1 Create Database Syntax: Examples: 1.2 Use Database Syntax: Examples: 1.3 View Current Database Syntax: Examples: 1.4 List All Data...","head":[["script",{"type":"application/ld+json"},"{\\"@context\\":\\"https://schema.org\\",\\"@type\\":\\"Article\\",\\"headline\\":\\"Metadata Operations\\",\\"image\\":[\\"\\"],\\"dateModified\\":\\"2026-01-12T10:25:39.000Z\\",\\"author\\":[]}"],["meta",{"property":"og:url","content":"https://iotdb.apache.org/UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.html"}],["meta",{"property":"og:site_name","content":"IoTDB Website"}],["meta",{"property":"og:title","content":"Metadata Operations"}],["meta",{"property":"og:description","content":"Metadata Operations 1. Database Management 1.1 Create Database Syntax: Examples: 1.2 Use Database Syntax: Examples: 1.3 View Current Database Syntax: Examples: 1.4 List All Data..."}],["meta",{"property":"og:type","content":"article"}],["meta",{"property":"og:locale","content":"en-US"}],["meta",{"property":"og:locale:alternate","content":"zh-CN"}],["meta",{"property":"og:updated_time","content":"2026-01-12T10:25:39.000Z"}],["meta",{"property":"article:modified_time","content":"2026-01-12T10:25:39.000Z"}],["link",{"rel":"alternate","hreflang":"zh-cn","href":"https://iotdb.apache.org/zh/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.27,"words":681},"filePathRelative":"UserGuide/latest-Table/SQL-Manual/SQL-Metadata-Operations.md","autoDesc":true}');export{b as comp,A as data}; |
