SHOW COLUMNS

Description

This statement is used to specify the column information of the table

grammar:

SHOW [FULL] COLUMNS FROM tbl;

Example

1. View the column information of the specified table

    SHOW FULL COLUMNS FROM tbl;

Keywords

SHOW, COLUMNS

Best Practice