Drop temporary table

[topci]

Hallo.

I have a little problem in MS Sql server. How cann i check when temporary table exist? I create more temp tables (create table #test_table ...) under some Sql connection; how cann i know, that this table not exist in connection?!

Please,help!

DaT

 

[vongrunt]

Simple:

if object_id('tempdb..#temptablename') is not null
begin
-- table exists
end

------
"There's a man... He's bald and wears a short-sleeved shirt, and somehow he's very important to me. I think his name is Homer."
(Jack O'Neill, Stargate)

 

[amrita418]

Or If you want to look at all the temp tables then go to ServerName --> TempDB --> user tables in the EM.

PS: All temp tables are dropped on user session log out.

Regards,
AA