Daevid Vincent Need query to determine different column definitions across tables
Jul 08, 2013; 14:10
Daevid Vincent
Need query to determine different column definitions across tables
I'm noticing that across our several databases and hundreds of tables that column definitions are not consistent. I'm wondering if there is a tool or query (using INFORMATION_SCHEMA perhaps) that will show me all databases, tables and columns where they don't match (by column name).
For example in one table `foo_id` might be UNSIGNED and in other's it is not. Or maybe it's INT(11) in some and INT(10) or worse MEDIUMINT in others. Or extending further Charset/Collation might mismatch and be that stupid "latin1_swedish_ci" and fixed to be "utf8" in others.
Stuff like that. I want to see everything where there is some difference.
Jul 09
Rick James RE: Need query to determine different column definitions across tables
Jul 09, 2013; 01:04
Rick James
RE: Need query to determine different column definitions across tables
Jul 08
Daevid Vincent RE: Need query to determine different column definitions across tables
Jul 08, 2013; 19:57
Daevid Vincent
RE: Need query to determine different column definitions across tables
Jul 10
Rick James RE: Need query to determine different column definitions across tables
Jul 10, 2013; 01:05
Rick James
RE: Need query to determine different column definitions across tables
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!