Using T-SQL to check whether a global temp table exists

[VenkatSQL]

Hi

How to check using T-SQL whether a global temp table exists or not...

thanks

s.v

 

[kaht]

http://www.devx.com/tips/Tip/13938

It's crazy, all I typed into google was "sql to check if a global temp table exists" and the link posted above was the 2nd link returned.


Who would have known google was so helpful? Crazy....

-kaht

Lisa, if you don't like your job you don't strike. You just go in every day and do it really half-assed. That's the American way. - Homer Simpson

[small]<P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <B> <P> <.</B>[/small]

 

[VenkatSQL]

Thanks lot

 

[bborissov]

[COLOR=blue]DECLARE[/color] @TableId [COLOR=blue]int[/color]
[COLOR=blue]SELECT[/color] @TableId = [COLOR=#FF00FF]OBJECT_ID[/color]([COLOR=red]'TempDB..##Test'[/color])
[COLOR=blue]SELECT[/color] @TableId

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[Crowley16]

or even just:

select object_id('tempdb..##test')

--------------------
Procrastinate Now!

 

[bborissov]

O! I missed the next part of the query:

[COLOR=blue]DECLARE[/color] @TableId [COLOR=blue]int[/color]
[COLOR=blue]SELECT[/color] @TableId = [COLOR=#FF00FF]OBJECT_ID[/color]([COLOR=red]'TempDB..##Test'[/color])
@TableId 
[COLOR=blue]IF[/color] @TableId [COLOR=blue]IS[/color] NULL
   [COLOR=green]-- Table does not exists
[/color][COLOR=blue]ELSE[/color]
   [COLOR=green]-- Table does exists[/color]

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP