Thursday, August 23, 2018

SQL - drop all temp tables

declare @sql nvarchar(max)
select @sql = isnull(@sql+';', '') + 'drop table ' + quotename(name)
from tempdb..sysobjects
where name like '#[^#]%'
exec (@sql)