Mysql: Query to show all tables and their collation

Is there a query that can be run in mysql that shows all tables and their default collation? Even better if there was on that could show all collations on all columns of all tables.

 Answers

SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
    FROM INFORMATION_SCHEMA.COLUMNS

---

Output information(status) about all tables in the database as "phpmyadmin":

SHOW TABLE STATUS FROM your_db_name;