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.

If your business uses relational databases to store data, it helps to use the SQL SELECT command with the INTO clause to create new tables from query results. This method isn't ANSI-standard SQL ...