SHOW-COLUMNS

Name

SHOW FULL COLUMNS

Description

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

Syntax:

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