​
Synopsis

SHOW COLUMNS FROM table [ LIKE pattern ]

​
Description

List the columns in a table along with their data type and other attributes:

SHOW COLUMNS FROM nation;

  Column   |     Type     | Extra | Comment
-----------+--------------+-------+---------
 nationkey | bigint       |       |
 name      | varchar(25)  |       |
 regionkey | bigint       |       |
 comment   | varchar(152) |       |

Specify a pattern in the optional LIKE clause to filter the results to the desired subset. For example, the following query allows you to find columns ending in key:

SHOW COLUMNS FROM nation LIKE '%key';

  Column   |     Type     | Extra | Comment
-----------+--------------+-------+---------
 nationkey | bigint       |       |
 regionkey | bigint       |       |
SHOW CATALOGSSHOW SCHEMAS