Difference between revisions of "SYSALERTS"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Yvonne.milne (Talk | contribs) |
||
(4 intermediate revisions by 2 users not shown) | |||
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]] | + | [[CLEAR TIMELINE]], [[SQL Data Types|DATA TYPES]], [[LIST TIMELINE]], [[ROLLBACK TIMELINE]], [[SQL SELECT|SELECT]], [[SET TIMELINE]], [[SET TIMESTAMP]], [[SQL System Tables|SYSTEM TABLES]], [[SYSTIMELINE]] |
− | + | ||
==Description== | ==Description== | ||
− | + | The sysperms table is stored in the system database and contains alert information for watched records. | |
− | + | {| class="wikitable" width="100%" | |
− | {| class="wikitable" | + | |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
Line 25: | Line 22: | ||
|- | |- | ||
|} | |} | ||
− | |||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | SELECT * FROM sysalerts WHERE user = user() | + | SELECT * FROM system!sysalerts WHERE user = user() |
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:System Tables]] | [[Category:System Tables]] |
Latest revision as of 06:05, 22 April 2020
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
The sysperms table is stored in the system database and contains alert information for watched records.
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 system!sysalerts WHERE user = user()