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

MS Sql Server LazyDBA home page