How can I determine that temporary table exists in SQL Server?

Question

When writing a T-SQL script that I plan on re-running, often times I use temporary tables to store temporary data. Since the temp table is created on the fly, I'd like to be able to drop that table only if it exists (before I create it).

I'll post the method that I use, but I'd like to see if there is a better way.

Answer 1

CREATE TABLE #Table(id INT)

--Check if it exists
IF OBJECT_ID('tempdb..#Table') IS NOT NULL
BEGIN
PRINT '#Table exists!'
END
ELSE
BEGIN
PRINT '#Table does not exist!'
END