SHOW COLUMNS

SHOW COLUMNS FROM table [ LIKE pattern ]

SHOW COLUMNS FROM nation;

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

SHOW COLUMNS FROM nation LIKE '%key';

  Column   |     Type     | Extra | Comment
-----------+--------------+-------+---------
 nationkey | bigint       |       |
 regionkey | bigint       |       |