Common sql statement

How to create default constrant for a column of a table

ALTER TABLE [dbo].[PolicyRecord] ADD  CONSTRAINT [DF_PolicyRecord_LastChangeTime]  DEFAULT (getdate()) FOR [LastChangeTime]

posted @ 2017-02-03 10:59  My_Litter_Princess  阅读(137)  评论(0编辑  收藏  举报