sql primary key and index

You are right, it’s confusing that SQL Server allows you to create duplicate indexes on the same field(s). But the fact that you can create another doesn’t indicate that the PK index doesn’t also already exist.

The additional index does no good, but the only harm (very small) is the additional file size and row-creation overhead.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)