SHOW COLUMNS#

Synopsis#

SHOW COLUMNS FROM table [ LIKE pattern ]

List the columns in table along with their data type and other attributes. The LIKE clause can be used to restrict the list of column names.