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


Horton, Joe (LNI) writes:

> 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
>



Darwin Li
MS Sql Server LazyDBA home page