troubleshooting Question

How Can I discovery if a tmp table exist?

Avatar of hidrau
hidrauFlag for Brazil asked on
Microsoft SQL Server
3 Comments1 Solution363 ViewsLast Modified:
This doesn't work when I want to know if there is already a tmp table created. How should it be?

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[#Q]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[#Q]
GO
ASKER CERTIFIED SOLUTION
Aneesh
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 3 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros