T-SQL: Test for the existence of a temporary table

Wednesday, May 07, 2008

This is actually right in the SQL Server Books Online, but not easily found. Given a temp table named #temp:

if ( object_id( 'tempdb..#temp' ) is null )
    -- table doesn't exist
else
    -- table exists

posted on May 7, 2008

Name
E-mail
Home page

	Remember Me
Comment (Some html is allowed: `a@href@title, i, strike, u`) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.
Enter the code shown (prevents robots):
Live Comment Preview