看看这段储存过程能不能帮你:CREATE PROCEDURE [dbo].[dropcolumn]
@vchTable nvarchar(50),
@vchField nvarchar(50)
asset nocount ondeclare @Col_ID int, @Tbl_ID int, @sql nvarchar(1024), @name varchar(50)select @tbl_id=object_id(@vchTable)
select @col_id=cdefault from syscolumns where id=@tbl_id and [name]=@vchFielddeclare curTmp cursor fast_forward local for
select name from sysobjects where parent_obj=@tbl_id and id=@col_id
open curTmp
fetch next from curTmp into @name
while @@fetch_status=0
begin
set @sql='alter table ' + @vchTable + ' drop CONSTRAINT ' + @name
exec(@sql)
fetch next from curTmp into @name
end
close curTmp
deallocate curTmpset @sql='alter table '+@vchtable+ ' drop column ' + @vchField
exec(@sql)
@vchTable nvarchar(50),
@vchField nvarchar(50)
asset nocount ondeclare @Col_ID int, @Tbl_ID int, @sql nvarchar(1024), @name varchar(50)select @tbl_id=object_id(@vchTable)
select @col_id=cdefault from syscolumns where id=@tbl_id and [name]=@vchFielddeclare curTmp cursor fast_forward local for
select name from sysobjects where parent_obj=@tbl_id and id=@col_id
open curTmp
fetch next from curTmp into @name
while @@fetch_status=0
begin
set @sql='alter table ' + @vchTable + ' drop CONSTRAINT ' + @name
exec(@sql)
fetch next from curTmp into @name
end
close curTmp
deallocate curTmpset @sql='alter table '+@vchtable+ ' drop column ' + @vchField
exec(@sql)
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货