SHOW COLUMNS
  FROM tbl_name
  [FROM db_name]
  [LIKE wild]
##</code><code>##

SELECT table_name, column_name
  FROM information_schema.columns