-- 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