SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_TYPE, COLUMN_COMMENT from information_schema.COLUMNS WHERE TABLE_SCHEMA = 'databasename'