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