[添加数据库字段属性]数据库字段属性说明修改 #db

修改字段说明.sql

-- ALTER TABLE MD_CustomerGroupSheet ADD IsPushed BIT

if exists(select 1 from sys.extended_properties p where
      p.major_id = object_id('MD_CustomerGroupSheet')
  and p.minor_id = (select c.column_id from sys.columns c where c.object_id = p.major_id and c.name = 'IsPushed')
)
begin
execute sp_dropextendedproperty 'MS_Description', 
   'user', 'dbo', 'table', 'MD_CustomerGroupSheet', 'column', 'IsPushed'
end

execute sp_addextendedproperty 'MS_Description', 
   '是否推送',
   'user', 'dbo', 'table', 'MD_CustomerGroupSheet', 'column', 'IsPushed'
go