Difference between revisions of "SYSALERTS"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Alert records for watched records | Alert records for watched records | ||
| − | |||
==See Also== | ==See Also== | ||
[[CLEAR TIMELINE]], [[SQL Data Types|DATA TYPES]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SQL SELECT|SELECT]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[SYSTIMELINE]], [[UNWATCH()]], [[WATCH()]], [[WATCHCHANGED()]], [[WATCHING()]], [[WATCHRESET()]] | [[CLEAR TIMELINE]], [[SQL Data Types|DATA TYPES]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SQL SELECT|SELECT]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[SYSTIMELINE]], [[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 25: | Line 22: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 32: | Line 28: | ||
</code> | </code> | ||
| − | |||
| − | |||
| − | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] | ||
Revision as of 13:19, 10 February 2012
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, 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 | 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()
