Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to check if a temp table exists
Message
From
26/08/2005 10:20:33
Sergey Berezniker
New York, United States
 
 
To
26/08/2005 06:06:15
Stanley Yip
Shun Sang (technology) ltd Hong Kong
Hong Kong, Hong Kong
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: How to check if a temp table exists
Miscellaneous
Thread ID:
01044235
Message ID:
01044299
Views:
18
>I use select into #temp to creat a #temp table
>then use what command to check if #temp in exits
>because I want to check if #temp is exits then drop it
IF object_id('tempdb..#temp01') IS NOT NULL
	DROP TABLE #temp01
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform