Query to show all tables and their collation

mysql schema collation
Parris Varney picture Parris Varney · Feb 9, 2011 · Viewed 35.3k times · Source

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.

Answer

Joe Stefanelli picture Joe Stefanelli · Feb 9, 2011 
SELECT TABLE_CATALOG, TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, COLLATION_NAME
    FROM INFORMATION_SCHEMA.COLUMNS

Related questions

How do I show the schema of a table in a MySQL database?

From the MySQL console, what command displays the schema of any given table?

Read More
Differences between INDEX, PRIMARY, UNIQUE, FULLTEXT in MySQL?

What are the differences between PRIMARY, UNIQUE, INDEX and FULLTEXT when creating MySQL tables? How would I use them?

Read More
Difference Between Schema / Database in MySQL

Is there a difference between a schema and a database in MySQL? In SQL Server, a database is a higher level container in relation to a schema. I read that Create Schema and Create Database do essentially the same thing …

Read More