Metadata views & functions

2016 (13.x) and later versions

Azure

SQL Managed Instance

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:

sys.tables

sys.columns

sys.periods

Information about temporal tables is exposed in the following metadata functions:

OBJECTPROPERTY

OBJECTPROPERTYEX

COLUMNPROPERTY

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