SHOW COLUMNS# Synopsis# SHOW COLUMNS FROM table [ LIKE pattern ] Description# 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.