SQL 2016 - Temporal Tables - Can you change the schema?
First published on MSDN on Dec 21, 2016 I was recently asked if after you setup a Temporal Table, can you modify the schema? It was a great question because if you cannot change the schema, then you would have to drop and recreate the table every time you need to change the schema which means you would potentially lose all the history.
