Sign in
Skip to solution
easyDSA

What is the difference between a primary key and a unique constraint?

1.1k views
01

Understand the problem

Compare PK and UNIQUE.

constraints
02

Attempt it yourself

Sketch your approach before reading the solution — that's what interviews test.

Nudge consolestandby

Stuck? Beam a request up — the console returns a conceptual nudge that guides your logic without spoiling the implementation.

03

Study the solution

Both enforce uniqueness, but a table has one primary key (not null, the main identifier, often clustered) while it can have multiple unique constraints, which may allow a NULL (depending on the DB). Use unique constraints for alternate keys like email.

Solution ready — 2 min read

Classified // press E to declassify

04

Run the code

SQLUnique Constraints Playground
05

Join the discussion

Discussion (0)

Sign in to join the discussion.

No responses yet. Be the first to share what you think.

Transmission complete // awaiting log

KEEP THE
STREAK ALIVE.

Dossier 3 of 70 decoded in the SQL track. One more won't hurt.

Back to track