急急急急急急急急急急急急急急急急！！！！如何修改所有表的某个字段，跟删除某个字段
如题，如何修改所有表的某个字段，跟删除某个字段，希望高手解答
[解决办法]
try this,
declare @tsql varchar(6000),@t varchar(50),@c varchar(50)
declare gz cursor forward_only
static for
select b.name 'tabname',a.name 'colname'
from sys.columns a
inner join sys.tables b on a.object_id=b.object_id
where a.name='[某个字段]'
open gz
fetch next from gz into @t,@c
while(@@fetch_status<>-1)
begin
select @tsql='alter table '+@t+' drop column '+@c
exec(@tsql)
fetch next from gz into @t,@c
end
close gz
deallocate gz
