Difference between revisions of "SYSTIMELINE"

Revision as of 16:12, 17 November 2009

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
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 of the master data server
TIMESTAMP	C	16	Timestamp from the master record
COMMAND	C	20	Command that changed the data
OLDDATA	M	8	Affected data prior to change
NEWDATA	M	8	Data after change

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

Recital, Recital Server

Revision as of 14:21, 17 November 2009 (view source) Yvonnemilne (Talk \| contribs) ← Older edit		Revision as of 16:12, 17 November 2009 (view source) Yvonnemilne (Talk \| contribs) Newer edit →
Line 4:		Line 4:

	==See Also==		==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]]