Difference between revisions of "SYSUSERS"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Yvonne.milne (Talk | contribs) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 3: | Line 3: | ||
==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 sysusers table is stored in the system database and holds username and email information for alerts for watched records. | |
− | {| class="wikitable" | + | {| class="wikitable" width="100%" |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
Line 19: | Line 19: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
− | SELECT * FROM sysusers WHERE user = user() | + | SELECT * FROM system!sysusers WHERE user = user() |
</code> | </code> | ||
Latest revision as of 06:22, 22 April 2020
Contents
Purpose
Username and email information for alerts for watched records
See Also
CLEAR TIMELINE, DATA TYPES, LIST TIMELINE, ROLLBACK TIMELINE, SELECT, SET TIMELINE, SET TIMESTAMP, SYSTEM TABLES, SYSTIMELINE
Description
The sysusers table is stored in the system database and holds username and email information for alerts for watched records.
Column | Data Type | Width | Description |
---|---|---|---|
USER | C | 20 | Name of user to alert (watching) |
C | 40 | Email address for user |
Example
SELECT * FROM system!sysusers WHERE user = user()