Remover All Columns

Remover All Columns.sql

declare @query varchar(max) = ''
DECLARE @Remove nvarchar(1000)

select 'ALTER TABLE '+ a.name + ' drop column ' + b.name + ''  as Remove
	into #temp
from sys.tables a
	inner join sys.columns b on b.object_id = a.object_id
	where b.name like '%ROW%'


declare cur cursor for
 select Remove from #temp

 open cur
 fetch cur into @Remove

 while @@FETCH_STATUS = 0
 begin
  execute sp_executesql @Remove 

  fetch cur into @Remove
 end

CLOSE cur
DEALLOCATE cur

drop table #temp