cannot drop statistics in sql server

I have a problem deleting one of the statistics in the table.
when i script
if  exists (select * from sys.stats where name = N'inx_add_1' and object_id = object_id(N'[dbo].[Call_Details_]'))
DROP STATISTICS [dbo].[Call_Details_].[inx_add_1]

then get an error below
Msg 3739, Level 11, State 1, Line 3
Cannot DROP the index 'dbo.Call_Details_.inx_add_1' because it is not a statistics collection.

any idea why is this happening, and when i  right click on the stats name the "script statistics as"  is grayed out by default. any idea friends....
Who is Participating?
YiogiConnect With a Mentor Commented:
It appears that it's an index and not statistics
try drop index instead
espanolanthonyAuthor Commented:
But there is no index bu that name
espanolanthonyAuthor Commented:
yes i got it. thanks i removed all the indexes expect PK then deleted stats and then recreated all the indexes again.

thanks for the highlight
espanolanthonyAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.