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