>>Some time ago I set up an alternate key (unique key) index (named AK_CompReference2). Now I want to drop it but when I try to Delete it in the SSMS I get error that "the index cannot be dropped because it is being used in UNIQUE KEY constraint enforcement" But what if I don't want this enforcement any more? How can I drop this index?
>
>Are you using it in a FK constraint ?
I was planning to but as far as I can tell, no.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham