SQL DROP TABLE IF EXISTS #tmpTable

DROP TABLE IF EXISTS #tmpTable

SELECT * 
INTO #tmpTable
FROM
TABLE