SQL删除带有默认值的列

DECLARE @name VARCHAR(100);
SELECT @name = b.name
FROM syscolumns a,
     sysobjects b
WHERE a.id = OBJECT_ID('EMS_Event') --tableName
      AND b.id = a.cdefault
      AND a.name = 'RequiredIndlicativeCount'--column name
      AND b.name LIKE 'DF%';

EXEC ('alter table EMS_Event drop constraint ' + @name); --EMS_Event -->tablenaem
ALTER TABLE EMS_Event DROP COLUMN RequiredIndlicativeCount;