IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.

« SQL Commands SELECT »

› › ›

DESCRIBE TABLE

edit

DESCRIBE TABLE

edit

Synopsis.

DESCRIBE table

DESC table

DescriptionDESC and DESCRIBE are aliases to SHOW COLUMNS.

DESCRIBE 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

« SQL Commands SELECT »