Skip to main content

SHOW-COLUMNS

SHOW-COLUMNS​

Name​

SHOW FULL 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​