Dropping PKs

Procedure to Find Candidate Keys

This Procedure will Display all the keys in a Specified Table

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.

Adding PK Exceptions to SQLCop Tests

In this piece, Steve Jones shows how you can enforce a requirement of a Primary Key (PK) with a unit test, but also allow exceptions where needed.

Unique Constraints

Auto-suggesting foreign keys and data model archaeology

If you can understand the data model then you can understand the intent of the application developers.

Deciding on a Primary Key in Oracle

Designing a system with primary keys in mind is not an easy task, and the solutions may not be the simplest. However the effort is well worth the time and trouble when you realize that it's the best way to prevent duplicate data - but how do you choose a primary key? David Fitzjarrell looks at several examples.

Questions about Primary and Foreign Keys You Were Too Shy to Ask

It is strange that one can ask simple questions about extended events or Hekaton at professional events and conferences without feeling embarrassed, yet nobody likes to ask vital questions about SQL Server primary keys and foreign keys. Fear not, here are 13 questions you were too shy to ask, answered.

Is a Primary Key an index?

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.