SQL Server 2016 Temporal tables
Whilst trying to create a temporal table (system versioned table) on SQL Server 2016, I kept getting a syntax error on the SET (SYSTEM_VERSIONING = ON) syntax stating that is was not supported.
After no success with changing the create table command, what I had to do was create the table without the system versioning on and then go and alter the table and set the system_versioning on and I also specified the History_Table.
If you want to alter or drop (or truncate) your system versioned table you will need to SET (SYSTEM_VERSIONING = OFF), make your changes and then turn it back on again.
I also added default constraints to the ValidFrom and ValidTo date fields and made these HIDDEN columns.