-- 删除字段
if exists (select * from syscolumns where id =object_id('Calendar_Detail') and name='Work_Flag')
ALTER TABLE [Calendar_Detail ] DROP COLUMN [Work_Flag]
if exists (select * from syscolumns where id =object_id('Calendar_Detail') and name='Work_Remark')
ALTER TABLE [Calendar_Detail ] DROP COLUMN [Work_Remark]
-- 添加字段
ALTER TABLE Calendar_Detail
ADD
Work_Flag int,
Work_Remark nvarchar(200)