Primary Key With Non Clustered Index Steve Hall no comments April 28, 2017 As a default, SQL Server creates a Primary Key column with a Clustered Index. However, this doesn’t have to be the case.