0

I have a SQL Server 2005 SP3 box that one of my developers created a temp table on that we cannot seem to remove because it somehow got brackets in the name of the table?

SELECT Name, object_id FROM sys.objects WHERE Name LIKE '%#example%'
Results:
Name        object_id
[#example]  123828384 

Anyone know how we can get rid of this? Thanks!

2 Answers 2

1

THe table wasn't showing up in SMS 2005, so I used SMS 2008 and ran as Administrator, and then I was able to remove the table via the GUI.

0

Just wrap the whole name with square brackets.

e.g.

drop table [[#example]

Should do it I think

1
  • That's what I tried first and it just returned a syntax error with "unclosed quotation mark after string" Jun 18, 2010 at 19:32

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .