批量删除列

declare @sql varchar(8000) set @sql=''

select @sql=@sql+' alter table ['+name+'] drop column DbName ' from sys.tables

--print @sql exec(@sql)