DESC#

Syntax#

DescStmt ::=
    'DESC' TableName

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

The DESC statement can display table details.

SQL Statement Template#

DESC table_name;

Example:#

Create a databasedb1:

CREATE DATABASE db1;
-- SUCCEED

CREATE DATABASE db2;
-- SUCCEED

Then select db1 as the current database:

USE db1;
-- SUCCEED: Database changed

Create two tables:

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

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_1658136511   col1   std_time   43200min   kAbsoluteTime
 --- -------------------- ------ ---------- ---------- ---------------
 --------------- --------------
  compress_type   storage_mode
 --------------- --------------
  NoCompress      Memory
 --------------- --------------