Difference between revisions of "SET TIMELINE"

From Lianjapedia
Jump to: navigation, search
Line 10: Line 10:
 
==Description==
 
==Description==
 
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.  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.
 
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.  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.
 
  
 
==Example==
 
==Example==

Revision as of 11:25, 7 December 2012

Purpose

Enable database timelines for row versioning

Syntax

SET TIMELINE ON | OFF

See Also

CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMESTAMP, SYSTIMELINE, TIMELINE()

Description

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. 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.

Example

set timeline on