>>>>Hi,
>>>>
>>>>Do you think it makes sense or matters to name unique index differently from any other index? For example, IX_tablename_columnname vs UX_tablename_columnname?
>>>
>>>It's a matter of preference. Doesn't make any difference for SQL Server.
>>
>>I understand that for SQL Server it does not matter. I probably should have asked what conventions people prefer. I read an on-line article by Pinal Dave (he writes a blog on SQL Server) where he makes many suggestions as to the naming conventions but never mentions the unique index key. So that brought up the question.
>>Thank you.
>
>You can create unique index by creating unique constraint (index will be created automatically). So, you can follow his naming conventions for unique constraint.
I don't see anywhere in his blog post where he talks about unique constraint. This is the page I am looking at:
http://blog.sqlauthority.com/2008/09/23/sql-server-coding-standards-guidelines-part-1/
"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