SQL ReferenceSQL StatementsShowSHOW-COLUMNSOn this pageSHOW-COLUMNSSHOW-COLUMNSNameSHOW FULL COLUMNSDescriptionThis statement is used to specify the column information of the tablegrammar:SHOW [FULL] COLUMNS FROM tbl;ExampleView the column information of the specified table SHOW FULL COLUMNS FROM tbl;KeywordsSHOW, COLUMNSBest Practice