Difference between revisions of "SYSTIMELINE"

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

Revision as of 08:56, 6 July 2011 (view source) Yvonnemilne (Talk \| contribs) ← Older edit		Revision as of 09:45, 6 July 2011 (view source) Yvonnemilne (Talk \| contribs) Newer edit →
Line 4:		Line 4:

	==See Also==		==See Also==
−	[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK 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()]]