Temporal Tables Automate Tracking Changes

SQL Server 2016 introduces a new type of table, called a temporal table. These tables automatically record data changes and the system date and time to provide a stronger audit trail to meet regulatory requirements than previous solutions. It also reduces the need for custom programming and third-party solutions that are often expensive to deploy and maintain and consume resources. The feature supports most column types and table features with some limitations, and most tables can be converted to a temporal table without impact to existing applications.

Become a DOM member or log in to read the full report