SHOW COLUMNS FROM table
List the columns in table along with their data type and other attributes.
table