Many types of database object alteration cannot be performed using the basic SQL ALTER statement. As usual, this varies from DBMS to DBMS and, indeed, from version to version of a single DBMS. Actions ...

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

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.