Microsoft SQL Server Drop Keyword Drop temporary tables
Example
In SQL server we have 2 types of temporary tables:
##GlobalTempTableis a type of temporary table that is sheered between all user's sessions.#LocalTempTabletemp tab - it is a type of temporary table that only exists in current scope (only in actual process - you can get id of your current process bySELECT @@SPID)
Droping process of temporary tables is the same as for normal table:
DROP TABLE [ database_name . [ schema_name ] . | schema_name . ] table_name
BEFORE SQL Server 2016:
IF(OBJECT_ID('tempdb..#TempTable') is not null)
DROP TABLE #TempTable;
SQL Server 2016:
DROP TABLE IF EXISTS #TempTable
