Default value: Today's date 1

[tseh]

How can I alter a table with a column called

Date_Entered

with the default of the date entered?

 

[jballum]

ALTER TABLE TableName WITH NOCHECK
ADD CONSTRAINT [DF_Date_Entered] DEFAULT getdate() FOR [Date_Entered]
GO

JB

 

[syntax18]

You can go to the design table on the enterprise manager and have a default value set to getdate() for the field