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.3] ›SQL Access ›SQL Commands

DESCRIBE TABLE

edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.

DESCRIBE TABLE

edit

Synopsis.

DESCRIBE table

or

DESC table

DescriptionDESC and DESCRIBE are aliases to SHOW COLUMNS.

DESCRIBE emp;

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