Skip to main content
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