SHOW COLUMNS

SHOW COLUMNS

Synopsis:

  1. SHOW COLUMNS
  2.     [CATALOG identifier]? 
  3.     [INCLUDE FROZEN]?     
  4.     [FROM | IN]
  5.     [table_identifier |   
  6.      LIKE pattern]

Catalog (cluster) identifier. Supports wildcards (*).

Whether or not to include frozen indices.

Single table (index or data stream) identifier or double-quoted multi-target pattern.

SQL LIKE pattern matching table names.

See index patterns for more information about patterns.

Description: List the columns in table and their data type (and other attributes).

  1. SHOW COLUMNS IN emp;
  3.        column       |     type      |    mapping
  4. --------------------+---------------+---------------
  5. birth_date          |TIMESTAMP      |datetime
  6. dep                 |STRUCT         |nested
  7. dep.dep_id          |VARCHAR        |keyword
  8. dep.dep_name        |VARCHAR        |text
  9. dep.dep_name.keyword|VARCHAR        |keyword
  10. dep.from_date       |TIMESTAMP      |datetime
  11. dep.to_date         |TIMESTAMP      |datetime
  12. emp_no              |INTEGER        |integer
  13. first_name          |VARCHAR        |text
  14. first_name.keyword  |VARCHAR        |keyword
  15. gender              |VARCHAR        |keyword
  16. hire_date           |TIMESTAMP      |datetime
  17. languages           |TINYINT        |byte
  18. last_name           |VARCHAR        |text
  19. last_name.keyword   |VARCHAR        |keyword
  20. name                |VARCHAR        |keyword
  21. salary              |INTEGER        |integer