>>>>>>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.