Cannot drop a table in SQL 2005

Question

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!

score 1 · Accepted Answer · answered Jun 17 '10 at 14:29

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.

answered Jun 17 '10 at 14:29

David Mathis

898
2
9
21

score 0 · Answer 2 · answered Jun 17 '10 at 14:32

0

Just wrap the whole name with square brackets.

e.g.

drop table [[#example]

Should do it I think

answered Jun 17 '10 at 14:32

Chris W

2,670
1
23
32

That's what I tried first and it just returned a syntax error with "unclosed quotation mark after string" – David Mathis Jun 18 '10 at 19:32

Cannot drop a table in SQL 2005

2 Answers2