« 9.36. SHOW CATALOGS 9.38. SHOW CREATE SCHEMA »
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.
table
LIKE