Difference between revisions of "SYSUSERS"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 8: | Line 8: | ||
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" width=100% | + | {| class="wikitable" width="100%" |
!Column||Data Type||Width||Description | !Column||Data Type||Width||Description | ||
|- | |- | ||
Revision as of 10:51, 31 January 2013
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
System Tables are system defined read-only tables. You can query these tables using the SELECT statement.
| Column | Data Type | Width | Description |
|---|---|---|---|
| USER | C | 20 | Name of user to alert (watching) |
| C | 40 | Email address for user |
Example
SELECT * FROM sysusers WHERE user = user()
