Temporal table metadata views and functions
Applies to:
SQL Server 2016 (13.x) and later
Azure SQL Database
Azure SQL Managed Instance
SQL Server and SQL Database include several metabase views and functions to enable administrators to retrieve information about temporal tables.
Information about temporal tables is exposed in the following metadata views:
Information about temporal tables is exposed in the following metadata functions:
Related content
- Temporal tables
- Get started with system-versioned temporal tables
- Temporal table system consistency checks
- Partition with temporal tables
- Temporal table considerations and limitations
- Temporal table security
- Manage retention of historical data in system-versioned temporal tables
- System-versioned temporal tables with memory-optimized tables