Support for Non-deterministic expressions or functions, such as GETDATE() or CURRENT_TIMESTAMP in default constraints

6 comments
-
Vishal Gupta commented
Need this feature for lot of auditing and migration activity !!!
-
Robert Kostecki commented
Must for any audit table ...
CREATE TABLE [Schema].[TableName]
(
[LoadTime] [datetime2] NOT NULL CONSTRAINT DF_TableName_LoadTime DEFAULT GETDATE(),
...
) -
Jason Horner commented
Agreed this should support functions like SYSDATETIME() and SUSER_NAME() too
-
Renata commented
What a joke this is not available :-(
-
Anubhav Agarwal commented
Any update on this? Need to add a default column with the current system date
-
Anonymous commented
What can be the alternative for this if this is not supported?
Any valid timeline for this??