SYSUSERS

From Recital Documentation Wiki
Revision as of 11:25, 21 September 2011 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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, 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
USER C 20 Name of user to alert (watching)
EMAIL C 40 Email address for user


Example

SELECT * FROM sysusers WHERE user = user()


Products

Recital, Recital Server