ALTER TABLE has been extended.
In addition to changes for entity and referential integrity, the following types of alterations are allowed:
DELETE column RENAME new-table-name RENAME old-column TO new-column
You can use MODIFY to change the maximum length of a character column, as well as converting from one data type to another.