What does the SQL temporal table (system-versioned table) feature provide?

Explanation

The SQL temporal table feature, also known as a system-versioned table, automatically tracks row history with system-maintained time periods. This enables AS OF queries to retrieve data as it existed at any past point in time.

Key points

System-versioned tables track row history automatically
AS OF queries can retrieve past data
Time periods are maintained by the system

Ready to go further?

Start full exam Practice more questions