添加删除带约束的列

最新推荐文章于 2021-04-03 21:29:03 发布

yhy80

最新推荐文章于 2021-04-03 21:29:03 发布

阅读量327

点赞数

文章标签： calendar table object null

本文链接：https://blog.csdn.net/yhy80/article/details/2654647

版权

-- 删除约束 DF_TSS_Calendar_IsTimeLess
if exists (select * from dbo.sysobjects where id = object_id(N'DF_TSS_Calendar_IsTimeLess') and OBJECTPROPERTY(id, N'IsConstraint') = 1)
  ALTER TABLE TSS_Calendar DROP CONSTRAINT DF_TSS_Calendar_IsTimeLess
GO
--删除列
if exists(select 1 from syscolumns where id=object_id('TSS_Calendar') and name='IsTimeLess')
   alter table TSS_Calendar DROP COLUMN IsTimeLess
GO
--添加带约束的列 WITH VALUES 的作用是 用默认值 填充已有的列
alter table TSS_Calendar add IsTimeLess int null
           CONSTRAINT DF_TSS_Calendar_IsTimeLess default(0) WITH VALUES
GO


ALTER TABLE [CBCUserMeasurementData] ADD CONSTRAINT DF_CBCUserMeasurementData_Pos DEFAULT 0 FOR [Pos]