>>>>>>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/>
>I have his book. The name convention he uses is:
>
>UQ_TableName_ColumnName
>
>-----------------------------
>Alter table HumanResources.RoomChart ADD CONSTRAINT UQ_RoomChart_RoomNotes UNIQUE (RoomNotes)
>
>----------------
I didn't know he wrote a book. Thank you.
"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