indexing - Drop an Index from SQL Server by Object ID -

indexing - Drop an Index from SQL Server by Object ID -

using sql server 2012 , have somehow ended w/ index named:

<name of missing index, sysname,>

i'm not sure how or when happened. i've tried dropping index using:

drop index email_address.<name of missing index, sysname,>

it won't of course of study since receive expected error message:

incorrect syntax near '<'.

querying dmv in sql server tells me should drop index it's more frustrating cannot. has been 1 of little things has gnawed @ me few years now. i've looked answers few times on years. i've poured 4 hours finding way drop index other name. nothing.

can help me? running query:

select * sys.indexes name = '<name of missing index, sysname,>'

produces object_id of 281104092. there way drop object using id? there must be, right? stuck w/ crazy index forever?

drop index email_address.[<name of missing index, sysname,>]

should trick.

object indexing