sql 删除默认索引，对象 依赖于 列，由于一个或多个对象访问此列

declare @name varchar(50)
select  @name =b.name from sysobjects b join syscolumns a
on b.id = a.cdefault
where a.id = object_id('table_name')
and a.name ='column_name'
select @name
if(@name)
exec('alter table table_name drop constraint ' + @name)

转载于:https://www.cnblogs.com/kiween/p/9754986.html