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 and LOAD, 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 in Reference: Statements and Options