› › ›

SHOW COLUMNS

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

© 2023-2025 Elasticsearch
As of September 2024, Elasticsearch is available under a choice of three licenses: the Server Side Public License (SSPL), the Elastic License, or the AGPLv3 (OSI approved).
Elasticsearch and the Elasticsearch logo are trademarks of Elasticsearch B.V., registered in the U.S. and in other countries.
https://www.elastic.co/guide/en/elasticsearch/reference/8.17/sql-syntax-show-columns.html