Adding DEFAULT Constraint For Existing Column in Table
CREATE TABLE tester
(dates datetime)
GO
ALTER TABLE [dbo].tester
ADD CONSTRAINT [DF__AccountMe__Creat__4D4A6AA9pppp] DEFAULT (getdate()) FOR dates
(dates datetime)
GO
ALTER TABLE [dbo].tester
ADD CONSTRAINT [DF__AccountMe__Creat__4D4A6AA9pppp] DEFAULT (getdate()) FOR dates
Comments