Skip Navigation LinksHome > SSW Standards > DeveloperSQLServer > SSW SQL Server Indexes Naming Standard

There was an error displaying the testimonials. Please report this error to SSW and include the following text:
- A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

  SQL Server Indexes Naming Standard

This standard outlines the procedure on naming Indexes at SSW for SQL Server. Use this standard when creating new Indexes or if you find an older Index that doesn't follow that standard.

Note: There is not a lot of use naming Indexes - we only do it when we are printing out documentation or using the 'Index Tuning Wizard' - then it becomes real handy.

Do you agree with them all? Are we missing some? Let us know what you think.


Index names are to have this syntax:
[pkc_] [TableName] by [FieldName]
[   1  ] [    2        ]      [    3       ]

[1] All indexes must have a corresponding prefix.

pkc_ Primary Key, Clustered
pknc_ Primary Key, Non Clustered
ncu_ Non Clustered, Unique
cu_ Clustered, Unique
nc_ Non Clustered (Most Common)


Make unique index name if possible. Ie. ProductName

[2] The name of the table that the Index refers to.

[3] The name of the column(s) that the Index refers to.


Old Style
Recommended Style
Index 'BillingID' 'nc_ClientDiary_BillingID'
Primary Key 'aaaaaClient_PK' 'pknc_ClientDiary_ClientID'


Adam Cogan