SHOW-COLUMNS

Name

SHOW FULL COLUMNS

Description

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

grammar:

1. SHOW [FULL] COLUMNS FROM tbl;

Example

1. View the column information of the specified table

1. SHOW FULL COLUMNS FROM tbl;

Keywords

1. SHOW, COLUMNS

Best Practice