In SQL Forum one of the posters asked a question about dropping all the temporary tables There are many ways to do this One of the ways to to run the following code declare @sql varchar(8000) set @sql='' select @sql = @sql+' drop table '+name from tempdb..sysobjects where xtype='u' exec(@sql)
declare @sql varchar(8000) set @sql='' select @sql = @sql+' drop table '+name from tempdb..sysobjects where xtype='u' exec(@sql)
Tags: t-sql, sql_server, drop,