Updated on 2022-11-18 GMT+08:00

SHOW COLUMNS

Syntax

SHOW COLUMNS [FROM | IN] table

Description

This expression is used to list the column information of a specified table.

Example

List the column information of the fruit table:

SHOW COLUMNS FROM fruit;
SHOW COLUMNS IN fruit;