Removing a double-quoted index

Question

I had a problem with the index. The name of the index "dbo.indexname"(including `` '') and I cannot delete it. Does anyone know how to remove an index with this name?

sp_help:

index_name, index_keys, index_description,  index_max_rows_per_page,       index_fillfactor,    index_reservepagegap,   index_created,  index_local

"dbo.index_name",    id, nonclustered, 0,           0,       0, Nov 27 2015  6:41PM,    Global Index

Output for: select * from sysindexes, where type name is '% dbo.index_name%'

name    id  indid   doampg  ioampg  oampgtrips  status3 status2 ipgtrips    first   root    distribution    usagecnt    segment status  maxrowsperpage  minlen  maxlen  maxirow keycnt  keys1
"dbo.index_name"    1259148500  3   0   0   0   0   0   0   0   0   0   0   1   0   0   15  15  15  2   81  00  06  00  01  00  00  bf  08  00  00  00  01  00  00  00  81  00  00  00  00  00  00  2d  06  00  00  00  09  00  00  00  

Answer 1

What is the name of the table? Suppose "mytab". Now do the following:

set quoted_identifier on go drop index mytab. "dbo.indexname" go

For some background, why this is puzzling, see http://www.sypron.nl/quiz2002a.html#dec02 .