Difference between revisions of "CLEAR TIMELINE"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
Line 24: | Line 24: | ||
[[Category:Commands]] | [[Category:Commands]] | ||
[[Category:Databases]] | [[Category:Databases]] | ||
+ | [[Category:Database Timelines]] |
Revision as of 11:17, 7 December 2012
Contents
Purpose
Clears database timeline transaction information
Syntax
CLEAR TIMELINE
See Also
DISPLAY TIMELINE, DTOS(), LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTIMELINE, TIME()
Description
CLEAR TIMELINE deletes database timeline transaction information. Database timelines provide row versioning for Recital database applications. Whenever a change is made to a table that is timeline enabled, delta changes are automatically recorded for each transaction.
CLEAR TIMELINE permanently deletes all records in the database timeline storage table, SYSTIMELINE.
To enable database timelines simply issue the SET TIMELINE ON command in your Recital configuration file. SET TIMELINE is OFF by default.
Example
clear timeline