sql添加表列字段描述添加默认值删除字段

sql添加表列字段描述添加默认值删除字段//删除表ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[JHCRM_Report_ss]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[JHCRM_Report_ss]//添加表ifnotexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[Table1]')andOBJECTPROPERTY(i