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, ...

I know in Oracle you can use DBA_TAB_COLUMNS (or ALL_TAB_COLUMNS). My SQL Server knowledge is very rusty, but can't you use the INFORMATION_SCHEMA.COLUMNS view ...