T-SQL筆記64_清空當前SSMS開啟的Session視窗下的temp table

 

DECLARE @d_sql NVARCHAR(MAX)

SET @d_sql = ''

SELECT @d_sql = @d_sql + 'DROP TABLE ' + QUOTENAME(name) + ';

'

FROM tempdb..sysobjects

WHERE name like '#[^#]%'

AND OBJECT_ID('tempdb..'+QUOTENAME(name)) IS NOT NULL

IF @d_sql <> ''

BEGIN

    PRINT @d_sql

    EXEC( @d_sql )

END

Ref:

https://stackoverflow.com/questions/5497450/drop-all-temporary-tables-for-an-instance