SYSALERTS
From Lianjapedia
Revision as of 10:37, 31 January 2013 by Helen.george (Talk | contribs)
Contents
Purpose
Alert records for watched records
See Also
CLEAR TIMELINE, DATA TYPES, LIST TIMELINE, ROLLBACK TIMELINE, SELECT, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, SYSTIMELINE
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 | Database name |
Table | C | 30 | Table name |
RUID | C | 16 | Record ID |
USER | C | 20 | Name of user to alert (watching) |
LASTALERT | I | 11 |
Example
SELECT * FROM sysalerts WHERE user = user()