declare @dfname varchar(50)
select @dfname=a.name
from sysobjects a
inner join syscomments b on a.id=b.id
inner join sysconstraints c on c.constid=a.id
inner join syscolumns d on c.colid=d.colid and c.id=d.id
where a.xtype='D' and object_name(d.id)='表名' and d.name='列名'
if @dfname is not null
exec('alter table 表名 drop constraint '+@dfname)
Go
alter table 表名 drop column 列名
Go
SQL删除有默认值字段(转)
最新推荐文章于 2024-09-03 17:40:17 发布