Difference between revisions of "SET TIMELINE"
|Line 6:||Line 6:|
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET ]], [[SET TIMESTAMP]], [[SYSTIMELINE]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
Revision as of 07:15, 26 March 2020
Enable database timelines for row versioning
SET TIMELINE ON | OFF
Database timelines provide row versioning for Lianja database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction. Changes made to any tables that are timeline enabled can be undone much like you would undo changes to program code that you edit in a text editor. SET TIMELINE is OFF by default.
Timelines can also be enabled for a specific database in its metadata. In the MetaData Editor specify the Attribute as timeline and the Value as on. Alternatively, use the ALTER DATABASE command as shown below.
set timeline on // Or set in the database metadata to always apply to the specified database alter database southwind metadata "timeline=on"