Difference between revisions of "SYSTIMELINE"

Latest revision as of 09:45, 6 July 2011

Stores database timelines row versioning records

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

SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')

Recital, Recital Server

@@ Line 4: / Line 4: @@
 ==See Also==
-[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]]
+[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]
@@ Line 13: / Line 13: @@
 {| class="wikitable"
 !Column||Data Type||Width||Description
+|-
+|DATABASE||C||30||Master database name
 |-
 |TABLE||C||30||Master table name
@@ Line 22: / Line 24: @@
 |USER||C||20||User login that changed the data
 |-
-|LOCATION||C||30||IP address of the master data server
+|LOCATION||C||30||IP address where data was changed from
 |-
-|TIMESTAMP||C||16||Timestamp from the master record
+|TIMESTAMP||C||16||Timestamp of change
 |-
 |COMMAND||C||20||Command that changed the data
 |-
-|OLDDATA||M||8||Data affected by change
+|OLDDATA||M||8||Data before change
 |-
-|NEWDATA||M||8||Affected data prior to change
+|NEWDATA||M||8||Data after change
 |-
 |}
@@ Line 46: / Line 48: @@
 [[Category:SQL]]
 [[Category:System Tables]]
+[[Category:Database Timelines]]