What are temporal tables in Azure SQL database and what are it's use cases?
Nandan Hegde
What are temporal tables in Azure SQL database and what are it’s use cases?
A temporal table is a type of table that allows SQL Server to maintain and manage the history of the data in the table automatically. This feature provides a full history of every change made to the data.When you create a temporal table, history table with the same schema gets automatically created. The history table stores previous versions of rows whenever a change is made to the data in the main table.Below are its use cases of Temporal tables: 1. Auditing 2. Used for historical trend analysis 3. Protecting data in case of accidental data loss 4. Rebuilding the data in case of inadvertent changes