HOW TO check if a temporary table exists before DROPping

To check if a temporary table already exists before DROPping, use

If Object_Id('tempdb..#big') is Not Null

Drop table #big

BTW, Are SQL Server Temp Tables Really Necessary?


Comments

Popular posts from this blog

Kai-Fu Lee on China-US AI Race - Q&A Transcript from a Bloomberg Interview

The Mercurial Grok AI Assistant Understands & Speaks Indian Languages

40 Talks from the Google Web AI Summit 2025