Difference between revisions of "SYSTIMELINE"

From Lianjapedia
Jump to: navigation, search
(See Also)
Line 3: Line 3:
  
 
==See Also==
 
==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[TIMELINE()]]
+
[[ALTER DATABASE]], [[CLEAR TIMELINE]], [[:Category:Database Timelines|Database Timelines Commands and Functions]], [[Database Timelines (Video)]], [[DTOS()]], [[LIST TIMELINE]], [[MetaData Editor]], [[ROLLBACK TIMELINE]], [[SET SYSTIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[TIMELINE()]], [[Timeline Section Attributes]], [[Understanding database timelines in Lianja|Understanding Database Timelines]]
  
 
==Description==
 
==Description==

Revision as of 10:33, 26 March 2020

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(timestamp, '20171001', '20171007')