View source for SYSTIMELINE

==Purpose==
Stores database timelines row versioning records


==See Also==
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]]


==Description==
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.


{| class="wikitable"
!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==
<code lang="recital">
SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')
</code>


==Products==
Recital, Recital Server
[[Category:Documentation]]
[[Category:SQL]]
[[Category:System Tables]]
[[Category:Database Timelines]]