SHOW COLUMNS¶ Synopsis¶ SHOW COLUMNS FROM table Description¶ List the columns in table along with their data type and other attributes such as Extra, Comment, Precision, Scale, and Length.