#temp table object_id

hortoristic · March 22nd, 2004, 08:34 PM

How come when I create a temp table as below, It does not show up in my OBJECT_ID? What I really need to do is test for the existence of a given temp table and drop it if it exists or create it if it doesnât.

CREATE TABLE #text (text_key VARCHAR (255), text_string TEXT NULL)
Select OBJECT_ID('#MyTempTable')

RETURNS:
NULL

_________________________
Joe Horton
Database Developer / Software Engineer
WISHA/Legal Services Software Development
Department of Labor and Industries
Voice (360) 902-5928 fax (360) 902-6200

Jeff Mason · March 22nd, 2004, 08:57 PM

Refer to the #temp table prefixing the database name (tempdb):

Code:

SELECT OBJECT_ID('tempdb..#text')

P.S. Remember that the temp table will be automatically deleted when the connection which created it goes away...

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com