What is the purpose of the SQL:2011 temporal table feature (system-versioned tables)?

Advanced SQL Developer Hard

Advanced SQL Developer — Hard

What is the purpose of the SQL:2011 temporal table feature (system-versioned tables)?

Key points

  • System-maintained valid-time periods track row history
  • AS OF queries retrieve data as it existed in the past
  • Useful for auditing and historical data analysis

Ready to go further?

Related questions