Tuesday, March 12, 2019

SQL Server Temporal Tables

Temporal Tables - SQL Server | Microsoft Docs

"SQL Server 2016 introduced support for temporal tables (also known as system-versioned temporal tables) as a database feature that brings built-in support for providing information about data stored in the table at any point in time rather than only the data that is correct at the current moment in time. Temporal is a database feature that was introduced in ANSI SQL 2011."
"How does temporal work?

System-versioning for a table is implemented as a pair of tables, a current table and a history table. Within each of these tables, the following two additional datetime2 columns are used to define the period of validity for each row: SysStartTime, SysEndTime "

PostgreSQL doesn’t support these features natively, but this temporal tables approximates them.

No comments: