CURRENT_TIMESTAMP and CURRENT_USER -
10-17-2011
, 05:29 PM
In Sybase 15, can I do the following:
CREATE TABLE ir_port_source
(
updated_by VARCHAR(128) DEFAULT CURRENT
USER,
updated_date TIMESTAMP DEFAULT CURRENT
TIMESTAMP
)
where on an update the updated_by and updated_date will automatically
be updated? This way I don't have to use an update trigger to update
the columns?
My syntax may be wrong. I have never done it before.
Does this work in Sybase 15? |