Tag Archives: Temporary Tables

Checking If A Local Temporary Table Already Exists

To test if a temporary table already exists, the “OBJECT_ID” system function can be used. For example the following code tests to see if the local temporary table ‘#AnyTable’ already exists and if the table exists the word ‘EXISTS’ is … Continue reading

Posted in SQL 2005, SQL 2008, SQL 2008 R2 | Tagged | Comments Off on Checking If A Local Temporary Table Already Exists