Pervasive logo

Prev SQL Engine Reference Next

USER


Remarks

The USER keyword returns the current user name (such as Master) for each row returned by the SELECT restriction.

Example

The following examples return the user name from the course table. 
 
SELECT USER FROM course  
		-- returns 145 instances of Master (the table contains 145 rows) 
SELECT DISTINCT USER FROM course  
		-- returns 1 instance of Master  

See Also

SELECT

SET SECURITY


Prev
UPDATE (positioned)
Contents
Up
Check for Revisions
Next
WHILE