使用SQL语句 删除添加字段

-- 删除字段

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)