IMPORTANT: No additional bug fixes or documentation updates
will be released for this version. For the latest information, see the
current release documentation.
SHOW COLUMNS
edit
IMPORTANT: This documentation is no longer updated. Refer to Elastic's version policy and the latest documentation.
SHOW COLUMNS
editSynopsis.
SHOW COLUMNS [ FROM | IN ] ? table
DescriptionList the columns in table and their data type (and other attributes).
SHOW COLUMNS IN 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