>>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?
>
>there are 2 patterns often used: just "ID" for the PK of every table or "ID_Tablename".
>Variations include PK_Tablename for primary and FK_Tablename for foreign keys.
>I personally prefer constant "ID_Tablename" as I always use the SQL alias in joins.
>
>Mostly a matter of habit and taste.
>
>HTH
>
>thomas
Thank you very much for your input.
"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