Often we need to create temp tables, and drop them every time we re-run the script.

-- if table exists, drop it
IF OBJECT_ID('tempdb..#temp') IS NOT NULL
BEGIN
    drop table #temp 
END

create table #temp (id int, name nvarchar(50))