Difference between revisions of "Database Timelines"

From Recital Documentation Wiki
Jump to: navigation, search
(Using Database Timelines)
(Undoing database changes)
Line 23: Line 23:
 
You can undo database changes with the '''ROLLBACK TIMELINE''' command.
 
You can undo database changes with the '''ROLLBACK TIMELINE''' command.
  
<code>
+
<pre>
 
ROLLBACK TIMELINE [RANGE begin [, end]] [FOR condition]
 
ROLLBACK TIMELINE [RANGE begin [, end]] [FOR condition]
</code>
+
</pre>
  
 
====Clearing a  timeline====
 
====Clearing a  timeline====

Revision as of 06:23, 2 November 2009

Database Timelines

What are Database Timelines?

Database timelines introduce row versioning to the Recital database engine. Whenever a change is made to a table that is timeline enabled then delta changes are automatically recorded for each transaction.

Using Database Timelines

To enable database timelines all you need to do is issue the SET TIMELINE ON command in your Recital configuration file.

Viewing a timeline

There are 2 ways to view a timeline.

  • The LIST TIMELINE command
  • The SELECT * FROM SYSTIMELINE command

LIST TIMELINE [RANGE begin [,end]] [FOR condition]

Undoing database changes

You can undo database changes with the ROLLBACK TIMELINE command.

ROLLBACK TIMELINE [RANGE begin [, end]] [FOR condition]

Clearing a timeline

The CLEAR TIMELINE command will reset a timeline.

CLEAR TIMELINE