SHOW COLUMNSedit

Warning

This functionality is experimental and may be changed or removed completely in a future release. Elastic will take a best effort approach to fix any issues, but experimental features are not subject to the support SLA of official GA features.

Synopsis. 

SHOW COLUMNS [ FROM | IN ]?
    [table identifier | 
    [LIKE pattern ] ]   

single table identifier or double quoted es multi index

SQL LIKE pattern

See index patterns for more information about patterns.

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

SHOW COLUMNS IN emp;

       column       |     type      |    mapping
--------------------+---------------+---------------
birth_date          |TIMESTAMP      |DATE
dep                 |STRUCT         |NESTED
dep.dep_id          |VARCHAR        |KEYWORD
dep.dep_name        |VARCHAR        |TEXT
dep.dep_name.keyword|VARCHAR        |KEYWORD
dep.from_date       |TIMESTAMP      |DATE
dep.to_date         |TIMESTAMP      |DATE
emp_no              |INTEGER        |INTEGER
first_name          |VARCHAR        |TEXT
first_name.keyword  |VARCHAR        |KEYWORD
gender              |VARCHAR        |KEYWORD
hire_date           |TIMESTAMP      |DATE
languages           |TINYINT        |BYTE
last_name           |VARCHAR        |TEXT
last_name.keyword   |VARCHAR        |KEYWORD
salary              |INTEGER        |INTEGER