Restriction: You cannot use any type of view in an ALTER TABLE statement. Restriction: You cannot use ALTER TABLE on a table that is accessed via an engine that does not support UPDATE processing.

The first form of the CREATE TABLE statement creates tables that automatically map SQL data types to those supported by the ... You can use an INSERT statement to add rows. Use an ALTER statement to ...