delete a from a left join b on a.field=b.field where b.field is null
declare @SQL nvarchar(2000) set @SQL = 'alter table A drop column 'select @SQL = @SQL + name + ',' from syscolumns where id = object_id(N'A') and name not in (select name from syscolumns where id = object_id(N'B') )set @SQL = left(@SQL,len(@SQL) - 1) print @SQL exec(@SQL)
delete a from a left join b on a.field=b.field where b.field is null
set @SQL = 'alter table A drop column 'select @SQL = @SQL + name + ','
from syscolumns
where id = object_id(N'A') and
name not in (select name from syscolumns where id = object_id(N'B') )set @SQL = left(@SQL,len(@SQL) - 1)
print @SQL
exec(@SQL)