Temporal Tables

readme.md

Features	CT	CDC	Temporal
Tracks Data Changes	Yes	Yes	Yes
Tracking mechanism	Synchronous	Asynchronous	Synchronous
Require enabling at Database Level	Yes	Yes	No
Require enabling at Table Level	Yes	Yes	Yes
Historical Data retention	No	Yes	Yes
Ability to Recover data from history	No	Yes	Yes
Requires change in current code	Yes	Yes	No
Table requires primary Key	Yes	Yes	Yes
Schema changes to the table allowed	Yes	No	Yes
Ability to analyze trends in data	No	No	Yes
Available in Standard Edition of SQL Server	Yes	No	Yes
History data is secure	No	No	Yes
Can you truncate history table?	Yes	Yes	No
History data resides in the same table	No	No	yes
Can you truncate main table?	Yes	No	No
Dependency on SQL Server Agent running	No	Yes	No