Compare two tables

[Alfredo Cole]

Hi:

I need to compare the structure of two tables (fields, field types, field 
lengths, indices, etc.) to determine if they have the same schema, even if 
the fields may be in a different order. Is there a command in mysql that will 
do this? This will be used to determine if the tables are basically the same, 
or if they need to be upgraded based on the table structures of a central 
office.

Thank you.

-- 
Alfredo J. Cole
Grupo ACyC