navigation
 Wednesday, May 07, 2008
T-SQL: Test for the existence of a temporary table

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  #    by Adam Anderson  Comments [0]
Related posts:
How To Write Secure Dynamic SQL
Good article about some lesser-known differences between temp tables and table variables
Dealing with #1.INF (Positive Infinity) in SQL Server
MSSQL System Stored Procedures Everyone Should Know
Hypothetical Indices
SQL Schema Comparison Tools

Copyright © 2003-2008 Falafel Software Inc.