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)

posted @ 2018-10-08 16:07  KiweenJain  阅读(2848)  评论(0编辑  收藏  举报