Temporal tables are a programmability feature of Azure SQL Database and Azure SQL Managed Instance that allows you to track and analyze the full history of changes in your data, without the need for custom coding. Temporal tables keep data closely related to time context so that stored facts can be interpreted as valid only within the specific period. GeoPITS brings you the comprehensive details of Temporal's support in different versions & editions of SQL Server.
Version | Enterprise | Standard | Web | Express (Adv.) | Express |
---|---|---|---|---|---|
Version v2019 | Yes | Yes | Yes | Yes | Yes |
Version v2017 | Yes | Yes | Yes | Yes | Yes |
Version v2016 | Yes | Yes | Yes | Yes | Yes |
Version v2014 | |||||
Version v2012 |
Temporal tables are a programmability feature of Azure SQL Database and Azure SQL Managed Instance that allows you to track and analyze the full history of changes in your data, without the need for custom coding. Temporal tables keep data closely related to time context so that stored facts can be interpreted as valid only within the specific period
You can find more details about this version here