SYSTIMELINE
From Recital Documentation Wiki
Revision as of 00:00, 2 December 2009 by Barrymavin (Talk | contribs)
Contents
Purpose
Stores database timelines row versioning records
See Also
CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES
Description
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| DATABASE | C | 30 | Master database name |
| TABLE | C | 30 | Master table name |
| RUID | C | 16 | Unique row id |
| RID | I | 11 | Table row id |
| USER | C | 20 | User login that changed the data |
| LOCATION | C | 30 | IP address where data was changed from |
| TIMESTAMP | C | 16 | Timestamp of change |
| COMMAND | C | 20 | Command that changed the data |
| OLDDATA | M | 8 | Data before change |
| NEWDATA | M | 8 | Data after change |
Example
SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')
Products
Recital, Recital Server
