查看表详情(DESC)

Syntax

DescStmt ::=
    'DESC' TableName

TableName ::=
    Identifier ('.' Identifier)?

DESC 语句可为用户展示表的详细信息。

SQL语句模版

DESC table_name;

Example:

创建一个数据库db1:

CREATE DATABASE db1;
-- SUCCEED: Create database successfully

CREATE DATABASE db2;
-- SUCCEED: Create database successfully

然后选择db1作为当前数据库：

USE db1;
-- SUCCEED: Database changed

创建两张表:

CREATE TABLE t1 (col0 STRING, col1 int, std_time TIMESTAMP, INDEX(KEY=col1, TS=std_time, TTL_TYPE=absolute, TTL=30d));
--SUCCEED: Create successfully

desc t1;
 --- ---------- ----------- ------ --------- 
  #   Field      Type        Null   Default  
 --- ---------- ----------- ------ --------- 
  1   col0       Varchar     YES             
  2   col1       Int         YES             
  3   std_time   Timestamp   YES             
 --- ---------- ----------- ------ --------- 
 --- -------------------- ------ ---------- ---------- --------------- 
  #   name                 keys   ts         ttl        ttl_type       
 --- -------------------- ------ ---------- ---------- --------------- 
  1   INDEX_0_1639524729   col1   std_time   43200min   kAbsoluteTime  
 --- -------------------- ------ ---------- ---------- --------------- 

相关语句

DROP DATABASE

SHOW DATABASES

SHOW TABLES