title: Query to show all tables and their collation
body: <p>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.</p>