--更新约束
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
相关文章
- 03-27constraint更新表列约束默认值