SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Learning About Temporal Tables

By Site Owners,

Temporal tables are designed to allow you to look at the history of data in a table. There are actually two tables that are used. A current table and a historical one. By querying the temporal table, one can learn how the data appeared at a specific point in the past.

Here are a list of links that might help you learn more. Note that many of these are links to other sites and we cannot guarantee they still work. We also should note that some of these, especially Books Online, may change over time.

If you find broken links or think we should have more here, please leave a comment in the discussion for this article.

Continue learning more about SQL Server

View the index of features for the various versions.

Total article views: 4502 | Views in the last 30 days: 6
Related Articles

Introduction To Temporal Tables In SQL Server 2016

Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Tempora...


SQL Server Temporal Tables

Temporal data storage, which was defined in the ANSI SQL:2011 standard, describes an architecture in...


How to drop a Temporal Table

No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called T...


Data Masker for SQL Server and Temporal Tables

A customer had a question recently about using Data Masker for SQL Server and temporal (or system ve...


System-Versioned Temporal Tables

Every once in a while, I like to take a moment and learn something new about the latest SQL Server.....