NON CLUSTERED ON PRIMARY KEY

SQL Server allows us to create NONCLUSTERED INDEX on Primary Key Column.... by default its CLUSTERED INDEX unless we specify NONCLUSTERED keyword while creation...


Sample code,

CREATE NONCLUSTERED INDEX  IX_NONCLUSTERED_PRIMARY ON TableName(PK_ColumnName)