Difference between revisions of "Database Timelines"
From Recital Documentation Wiki
Barrymavin (Talk | contribs) (→Using Database Timelines) |
Barrymavin (Talk | contribs) (→Using Database Timelines) |
||
| Line 8: | Line 8: | ||
To enable database timelines all you need to do is issue the '''SET TIMELINE ON''' command in your Recital configuration file. | 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. | There are 2 ways to view a timeline. | ||
* The '''LIST TIMELINE''' command | * The '''LIST TIMELINE''' command | ||
| − | * The '''SELECT * FROM TIMELINE''' command | + | * The '''SELECT * FROM SYSTIMELINE''' command |
| + | |||
| + | <code> | ||
| + | LIST TIMELINE [RANGE begin [,end]] [FOR condition] | ||
| + | </code> | ||
| + | |||
| + | ====Undoing database changes==== | ||
| + | |||
| + | You can undo database changes with the '''ROLLBACK TIMELINE''' command. | ||
| + | |||
| + | <code> | ||
| + | ROLLBACK TIMELINE [RANGE begin [, end]] [FOR condition] | ||
| + | </code> | ||
| + | |||
| + | ====Clearing a timeline==== | ||
| + | |||
| + | The '''CLEAR TIMELINE''' command will reset a timeline. | ||
| + | |||
| + | <code> | ||
| + | CLEAR TIMELINE | ||
| + | </code> | ||
Revision as of 06:23, 2 November 2009
Contents
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
