In this article I’ll cover all aspects of a new SQL Server 2016 feature, Temporal Tables (System-Versioned), including:
- What is a temporal table?
- Why Temporal table?
- How does temporal table work?
- Consideration and limitation
- Temporal tables vs CDC
- Creation and configuration
- Clean up and removal
AS we know, Microsoft released SQL Server 2016 RTM version (13.00.1601.5) and in November of 2016 updated it by the latest CU (Security Bulletin MS16-136 (CU) KB #3194717) (13.0.2186.0) you can check this update from here.
To complete the post please check it over SQLShack