Difference between revisions of "SYSTIMELINE"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Stores database timelines row versioning records | Stores database timelines row versioning records | ||
| − | |||
==See Also== | ==See Also== | ||
[[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]] | [[CLEAR TIMELINE]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]] | ||
| − | |||
==Description== | ==Description== | ||
System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | System Tables are system defined read-only tables. You can query these tables using the SELECT statement. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 35: | Line 32: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 42: | Line 38: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
[[Category:Database Timelines]] | [[Category:Database Timelines]] | ||
Revision as of 13:19, 10 February 2012
Contents
Purpose
Stores database timelines row versioning records
See Also
CLEAR TIMELINE, LIST TIMELINE, ROLLBACK TIMELINE, SET TIMELINE, SET TIMESTAMP, 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.
| 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
SELECT * FROM systimeline WHERE between(timestamp, '20091001', '20091007')
