IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« SQL Commands SELECT »
Elastic Docs ›Elasticsearch Guide [6.7] ›SQL Access ›SQL Commands

DESCRIBE TABLE

edit

DESCRIBE TABLE

edit

Synopsis.

DESCRIBE
    [table identifier | 
    [LIKE pattern]]

single table identifier or double quoted es multi index

SQL LIKE pattern

or

DESC
    [table identifier | 
    [LIKE pattern]]

single table identifier or double quoted es multi index

SQL LIKE pattern

DescriptionDESC and DESCRIBE are aliases to SHOW COLUMNS.

DESCRIBE emp;

       column       |     type      |    mapping
--------------------+---------------+---------------
birth_date          |TIMESTAMP      |datetime
dep                 |STRUCT         |nested
dep.dep_id          |VARCHAR        |keyword
dep.dep_name        |VARCHAR        |text
dep.dep_name.keyword|VARCHAR        |keyword
dep.from_date       |TIMESTAMP      |datetime
dep.to_date         |TIMESTAMP      |datetime
emp_no              |INTEGER        |integer
first_name          |VARCHAR        |text
first_name.keyword  |VARCHAR        |keyword
gender              |VARCHAR        |keyword
hire_date           |TIMESTAMP      |datetime
languages           |TINYINT        |byte
last_name           |VARCHAR        |text
last_name.keyword   |VARCHAR        |keyword
salary              |INTEGER        |integer
« SQL Commands SELECT »