{DESCRIBE | DESC} tbl_name [col_name | wild]
Supplies information about the columns, a specific column (col_name), or any columns that match a pattern containing wild cards ‘%’ and ‘_’ (wild), that make up the specified table. The information returned includes the column name, its type, whether it accepts NULL as a value, whether the column has an index, the default value for the column, and any extra features it has (e.g. AUTO_INCREMENT).