Contents Index CURRENT UTC TIMESTAMP special value SQLCODE special value

ASA SQL Reference
  SQL Language Elements
    Special values

LAST USER special value


Function 

The name of the user who last modified the row.

Data type 

String.

LAST USER can be used as a default value in columns with character data types.

Description 

On INSERT, this constant has the same effect as CURRENT USER. On UPDATE, if a column with a default value of LAST USER is not explicitly modified, it is changed to the name of the current user.

When combined with the DEFAULT TIMESTAMP, a default value of LAST USER can be used to record (in separate columns) both the user and the date and time a row was last changed.

See also 

CURRENT USER special value

CURRENT TIMESTAMP special value

CREATE TABLE statement


Contents Index CURRENT UTC TIMESTAMP special value SQLCODE special value