SHOW COLUMNSedit

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
--------------------+---------------
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