Some things are taken care of for you: If you alter the schema of a temporal table (by adding a new column, for example), SQL Server will take care of copying the change to your historical table. But, ...

and changes column attributes in an existing table. Adds, modifies, and drops integrity constraints from an existing table. Restriction: You cannot use any type of view in an ALTER TABLE statement.