NOTE: You are looking at documentation for an older release. For the latest information, see the current release documentation.

« SELECT SHOW FUNCTIONS »

› › ›

SHOW COLUMNS

edit

SHOW COLUMNS

edit

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.

DescriptionList 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
salary              |INTEGER        |integer

« SELECT SHOW FUNCTIONS »