Table schema is stored in INFORMATION_SCHEMA. You may have a home-grown script to query and compare the schema. Related tables are: tables, columns, key_column_usage,...