SQL Server Index Naming Conventions [closed]
Solution 1:
I use
PK_ for primary keys
UK_ for unique keys
IX_ for non clustered non unique indexes
UX_ for unique indexes
All of my index name take the form of<index or key type>_<table name>_<column 1>_<column 2>_<column n>
Solution 2:
I usually name indexes by the name of the table and the columns they contain:
ix_tablename_col1_col2