SQL Server Index Naming Conventions

SQL Server Index Naming Conventions [closed]

回答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>

 

回答2

I usually name indexes by the name of the table and the columns they contain:

ix_tablename_col1_col2