SYSTIMELINE
From Lianjapedia
Revision as of 17:55, 27 March 2020 by Barrymavin (Talk | contribs)
Contents
Purpose
Stores database timelines row versioning records
See Also
ALTER DATABASE, CLEAR TIMELINE, Database Timelines Commands and Functions, Database Timelines (Video), DTOS(), LIST TIMELINE, MetaData Editor, ROLLBACK TIMELINE, SET SYSTIMELINE, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, TIMELINE(), Timeline Section Attributes, Understanding Database Timelines
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 |
Note: the systimeline table only exists after SET TIMELINE has been set ON and timeline entries have been created.
Example
SELECT * FROM system!systimeline WHERE between(left(timestamp,8), '20171001', '20171007')
