>>>One more thing to add to my initial message. I see this name ( AK_CompReference2) in Keys node and in the Indexes node. And attempting to delete it in either place fails. So my question is, should I modify it first? And if so, does it matter in which node do I modify it?
>>
>>Try to delete it through a Table Designer, Indexes.
>
>This does it. Thank you.
>
>Do you think I was able to delete it in the Table Designer, Indexes because this is where I created this index? (Honestly I don't remember doing it there but I don't remember what I had for breakfast either <g>).

What was wrong in doing it through the code? BTW, did you script when you deleted it (just to see what code was generated)?