constraint更新表列约束默认值

--更新约束

alter TABLE [dbo].[Sk_Recruit]

drop

constraint

DF_Sk_Recruit_lastcommenttime

go

 

alter TABLE [dbo].[Sk_Recruit]

add

constraint

DF_Sk_Recruit_lastcommenttime

DEFAULT (getdate())

for [lastcommenttime]

go