Difference between revisions of "CLEAR TIMELINE"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) (→See Also) |
||
(6 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Clears database timeline transaction information | Clears database timeline transaction information | ||
− | |||
==Syntax== | ==Syntax== | ||
CLEAR TIMELINE | CLEAR TIMELINE | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ | + | [[ALTER DATABASE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[DTOS()]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SYSTIMELINE|Systimeline System Table]], [[TIME()]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]] |
− | + | ||
==Description== | ==Description== | ||
− | CLEAR TIMELINE deletes database timeline transaction information. Database timelines provide row versioning for | + | CLEAR TIMELINE deletes database timeline transaction information. 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. |
CLEAR TIMELINE permanently deletes all records in the database timeline storage table, [[SYSTIMELINE]]. | 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 | + | To enable database timelines simply issue the SET TIMELINE ON command in your Lianja configuration file. SET TIMELINE is OFF by default. |
− | + | ||
==Example== | ==Example== | ||
Line 24: | Line 20: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
+ | [[Category:Databases]] | ||
[[Category:Database Timelines]] | [[Category:Database Timelines]] | ||
+ | [[Category:Lianja VFP Extensions]] | ||
+ | [[Category:VFP Command Extensions]] |
Latest revision as of 10:31, 26 March 2020
Contents
Purpose
Clears database timeline transaction information
Syntax
CLEAR TIMELINE
See Also
ALTER DATABASE, Database Timelines Commands and Functions, Database Timelines (Video), DTOS(), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMELINE, SET TIMESTAMP, Systimeline System Table, TIME(), TIMELINE(), Timeline Section Attributes, Understanding Database Timelines
Description
CLEAR TIMELINE deletes database timeline transaction information. 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.
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 Lianja configuration file. SET TIMELINE is OFF by default.
Example
clear timeline