# DESC 

## Syntax

```sql
DescStmt ::=
    'DESC' TableName

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

The `DESC` statement can display table details.

## SQL Statement Template

```sql
DESC table_name;
```

## Example:

Create a database`db1`:

```sql
CREATE DATABASE db1;
-- SUCCEED

CREATE DATABASE db2;
-- SUCCEED
```

Then select `db1` as the current database:

```sql
USE db1;
-- SUCCEED: Database changed
```

Create two tables:

```sql
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
 --------------- --------------

```



## Related Terms 

[DROP DATABASE](./DROP_DATABASE_STATEMENT.md)

[SHOW DATABASES](./SHOW_DATABASES_STATEMENT.md)

[SHOW TABLES](./SHOW_TABLES_STATEMENT.md)