EXPLAIN ALTER TABLE

alter table is sufficiently complex that it would be very handy if there was a way to list all the operations and the order in which they're going to happen.

Specifically:

• What lock will be requested
• Will a table rewrite be needed
• Will a table read to verify a constraint be needed

etc?