On this page

SHOW COLUMNS

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

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;
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback