This documentation contains work-in-progress information for future Elastic Stack and Cloud releases. Use the version selector to view supported release docs. It also contains some Elastic Cloud serverless information. Check out our serverless docs for more details.
« SHOW CATALOGS SHOW FUNCTIONS »
Elastic Docs ›Elasticsearch Guide [master] ›SQL ›SQL Language

SHOW COLUMNS

edit

SHOW COLUMNS

edit

Synopsis:

SHOW COLUMNS
    [CATALOG identifier]? 
    [INCLUDE FROZEN]?     
    [FROM | IN]
    [table_identifier |   
     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).

SHOW COLUMNS IN 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
name                |VARCHAR        |keyword
salary              |INTEGER        |integer
« SHOW CATALOGS SHOW FUNCTIONS »